 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
yichun
Guest
|
 Posted: Wed May 12, 2004 11:22 am Post subject: What is causes of SQL Time Out Error |
 |
|
My client recently complain that the reaction of our software is pretty
slow, i have to log the SQL statement through SQL monitor.
The log is as below:
1480 16:39:49 SQL Prepare: MSSQL - SELECT * FROM SYN_LICENSE WHERE
COMPANY_KEY = '@LICENSE'
1481 16:39:49 SQL Misc: MSSQL - Set statement type
1482 16:39:49 SQL Execute: MSSQL - SELECT * FROM SYN_LICENSE WHERE
COMPANY_KEY = '@LICENSE'
1483 16:39:49 SQL Vendor: MSSQL - dbcmd
1484 16:39:49 SQL Vendor: MSSQL - dbsqlexec
1485 16:41:37 SQL Vendor: MSSQL - dbresults
1486 16:41:37 SQL Vendor: MSSQL - dbnumcols
1487 16:41:37 SQL Vendor: MSSQL - dbcount
above is the log file from SQL Monitor, line 1484 and 1485 have a 2 minute
delay, if this delay take time >5 minute that i set in TDatabase's Param
MAX QUERY TIME=300,
then a SQL Time Out Error will be triggered.
The table SYN_LICENSE only have 4 record inside. I am using SQL2000, D3.
NativeDriver.
Can some body tell me what is the cause of delay?
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
