U++ framework: U++ SQL » Problem when call a BIG stored procedure !

Home » U++ Library support » U++ SQL » Problem when call a BIG stored procedure !

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem when call a BIG stored procedure ! [message #36851]

Thu, 12 July 2012 02:22

akebee
Messages: 90
Registered: August 2011
Location: China

Member

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?

Report message to a moderator

Re: Problem when call a BIG stored procedure ! [message #36874 is a reply to message #36851]

Sun, 15 July 2012 21:23

mirek
Messages: 14290
Registered: November 2005

Ultimate Member

akebee wrote on Wed, 11 July 2012 20:22

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.

Report message to a moderator

Re: Problem when call a BIG stored procedure ! [message #37199 is a reply to message #36874]

Wed, 05 September 2012 01:12

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

Report message to a moderator

Previous Topic:	Multi-column unique index
Next Topic:	How do I load sqlite3 .sql with triggers on it?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 25 14:12:31 GMT+2 2026

Total time taken to generate the page: 0.01068 seconds