TheMasterShake
February 13th, 2008, 08:38 AM
I have a problem with a web application I have built. Here are the specifications of my current system:
Database - Oracle 10g
Web code - ASP .NET 2.0
web server - IIS 6
System DSN - Microsoft ODBC for Oracle
My Connection happens instantly, but when I attempt to use a data adapter to fill a DataTable, it takes well over a minute to run the query. When I run the exact same query in Toad (pl/sql IDE) it takes less than a second. When I built a test console application the same query runs in 10 seconds (which is still a very long time in my eyes). I have an old system that runs on oracle 9i and the same query through the web takes about 2 seconds. I have compared the IIS configuration and web.config files for the old and new systems, they are identical. The system DSNs are configured the same way. What could be causing this slowness?
Database - Oracle 10g
Web code - ASP .NET 2.0
web server - IIS 6
System DSN - Microsoft ODBC for Oracle
My Connection happens instantly, but when I attempt to use a data adapter to fill a DataTable, it takes well over a minute to run the query. When I run the exact same query in Toad (pl/sql IDE) it takes less than a second. When I built a test console application the same query runs in 10 seconds (which is still a very long time in my eyes). I have an old system that runs on oracle 9i and the same query through the web takes about 2 seconds. I have compared the IIS configuration and web.config files for the old and new systems, they are identical. The system DSNs are configured the same way. What could be causing this slowness?