General information
Category:
Database DAO/RDO/ODBC/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
Hi,
Did u try to used stored procedure or there is a tendency to make slow down the SQL or Query if there are many variable you declare within your stored procedure...
Avoid using to many variables or DECLARE in your stored to procedure to avoid slow retrieving the records....
TIA
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