Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Performance issue with ADO
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
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