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