we waited for almost a full day but still not getting any response
Sai Hegde wrote:Just a 'Select *' wont. But it is difficult to believe that returning 30k rows required 5 minutes.
Scott Selikoff wrote:BTW returning 30,000 results to the user is... bad... taking 5 minutes to do so is even worse. You should consider pagination to split up the results and indexes to improve performance and/or materialized views.
Scott Selikoff wrote:Actually, it's the idea of transferring 30,000 records from a database. This feels like the kind of thing a stored procedure could solve and eliminate the need to transfer that much data from the database.
NitishK Kumar wrote:... but when you are retrieving such a large amount of data from the database you must set the resultset fetchsize, which is by default is set to 10. Please refer the following link http://download.oracle.com/javase/6/docs/api/index.html.