Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Problem when call a BIG stored procedure !
icon5.gif  Problem when call a BIG stored procedure ! [message #36851] Thu, 12 July 2012 02:22 Go to next message
akebee is currently offline  akebee
Messages: 90
Registered: August 2011
Location: China
Member
Embarassed

The database is MSSQL.

i use blew code to call a stored procedure:
SQL.Execute("StoredProcedure");


if the database has BIG data,this code will execute not sucess!
i debug and step over this code,found that it has no delay!
but in fact this stored procedure execute at least cost 1 second,

i do not know why ? can you help me?
Re: Problem when call a BIG stored procedure ! [message #36874 is a reply to message #36851] Sun, 15 July 2012 21:23 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
akebee wrote on Wed, 11 July 2012 20:22

Embarassed

The database is MSSQL.

i use blew code to call a stored procedure:
SQL.Execute("StoredProcedure");


if the database has BIG data,this code will execute not sucess!



Well, if it does execute with different dataset, I would suspect an error in StoredProcedure.
Re: Problem when call a BIG stored procedure ! [message #37199 is a reply to message #36874] Wed, 05 September 2012 01:12 Go to previous message
akebee is currently offline  akebee
Messages: 90
Registered: August 2011
Location: China
Member
By the way, the stored procedure will generated a table,i found that it execute sucess in fact, when i wait for some seconds
suc as:

TimeStop tm;
while(true)
{
 if(tm.Elapsed() > 10*1000)
    break;
}


// now the table has generated i can fetch it
sql.Execute("select date('now')");
while(sql.Fetch())
{
}


so the problem is how to know the procedure has completed, has any idea? Confused
Previous Topic: Multi-column unique index
Next Topic: How do I load sqlite3 .sql with triggers on it?
Goto Forum:
  


Current Time: Thu Mar 28 16:37:45 CET 2024

Total time taken to generate the page: 0.00826 seconds