Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance issue with ADO
Message
De
29/11/2001 12:13:24
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Performance issue with ADO
Divers
Thread ID:
00587543
Message ID:
00587543
Vues:
56
Ok masters,

I need some help. I am having a result set performance issue. A result set that normally takes less that a second to retrieve, is taking minutes. I am using ADO against an Oracle database through VB 6.0. I can take the exact SQL Statement and run it on the database, and it will come back with my row in under a second. But, if I run it inside of VB through ADO, it is taking minutes. This has worked just fine for six months, and with no program changes, it is now a problem. I can't figure out what could be holding up my connection. Is there some ADO log file that is being generated or some other external factors that I should consider? Has anyone seen this?

Thanks for you help,
Brad
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform