Server Application Unavailable

[aaru24x7]

We are using .net application with oracle 9i database,we are trying to run a join query through our application but we are getting Server Application Unavailable error after the program runs for 5 minutes. we are using Windows 2003 operating system.how to increase the query performance through .net application. There are three queries that run the aspx (output is a report in aspx). The first query returns between 9 - 18 records and is displayed horizontally. The second query returns around 150 records. The third query returns one record for the combination of first and second query. Thanks

[Colin Angus Mackay]

Have you put a break point in your code, or trace statements to verify what is taking the time? If it is the database queries (when you get the data through the DataAdapter or DataReader) then the problem is likely with your database. How long does it take to run these queries through Oracle's tools? If it takes a long time to run the queries then consider adding indexes. The columns specified in the where clause and the join are generally good candidates. If Oracle has a query profiler to assist in index tuning you might want to use that to see where the bottlenecks in the query are.

---

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog