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.