PDA

View Full Version : Query response time



smplaw@sinaman.com
10-29-2003, 03:56 AM
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.

K.Forsythe
10-29-2003, 03:56 AM
Can you show the SQL statement? Kevin