Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query response time

Status
Not open for further replies.
smplaw

smplaw

Programmer
Sep 12, 2001
5
HK
In a VB program, there is a SQL query pass to SQL server using RDO. When this query was used in two forms, the query response time was quite different. It takes much more time to get the resultset than the one in another form. I tried to get the ODBC traced data to find out the problems and they worked normal.
Does anyone know how to figure out the causes of these difference?

Thanks.
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
1K
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
population of italy live/real time
Replies
11
Views
374
strongm
strongm
Swi
  • Locked
  • Question
Date/Time Conversion 1
Replies
2
Views
169
Swi
Swi
sal21
  • Locked
  • Question
FORMAT output of Debug.Print .responseText (from api rest)
Replies
4
Views
388
2009luca
2009luca
f0rg3tfu1
  • Locked
  • Question
circular reference caused by alias in query definition
Replies
7
Views
442
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top