Information générale
Catégorie:
Bases de données 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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement