Nikhil Pasupukuntla
SCJP 1.5 | OCPJWCD 1.5
we waited for almost a full day but still not getting any response
[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
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.
[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
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.
Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters? |