General information
Category:
Database DAO/RDO/ODBC/ADO
>Hy !
>
>I'have this little problem
>
>In my VB application (ADO), when i'm running a query through ODBC,
>it's 10 times slower than in the Query analyser of SQlServer.
>
>Is there a way or a method to execute it faster ???
>Like a passthrough query ?? that is not interpreted by ODBC
>
>Thanks
>
>L-A
You can probably speed things up by selecting a lighweight cursor type like the forward only, read only depending on your needs. Given the same conditions, there should not be a lot of difference between the two, query analyzer uses ODBC also to communicate with SQL Server.
Alternatively you can test different settings of the Cachesize property of the recordset object, and select the one that gives you the best results.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only