This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Even If you are getting the rows in friction of second from the database what about the time it takes to deliver the data from server to client, the time it takes to render and other stuffs? You may minimize the number of results dispatched to the client to improve performance some bits. [ October 18, 2008: Message edited by: Chandra Bhatt ]
Joined: May 29, 2008
Hi chandra , Thanks for your post. Currently I am working on one form which is developed using d2k and oracle 9i as database. in that form the same result will be displayed within 1 sec. now i have to change this form using java as front end and same oracle database.
Is there no any alternative for my work. Thanks and regards Harshal
Currently I am working on one form which is developed using d2k and oracle 9i as database. In that form the same result will be displayed within 1 sec.
"d2k" is Developer 2000, I presume? Are you sure that the entire 8000 rows of the result set are returned within one second? The Oracle JDBC driver returns result set rows in groups of 10 (ten), by default. This number can be increased using the "setFetchSize()" method(s). See interfaces "java.sql.ResultSet" and "java.sql.Statement". Also refer to the "JDBC Developer's Guide and Reference", part of the Oracle documentation, that explains how Oracle's JDBC driver handles these methods. I suggest you use pagination. I recommend searching the Internet for the terms "jdbc" and "pagination", or "paging". A user cannot possibly view 8000 rows in one shot.
Good Luck, Avi.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: How to increase speed while retrieving data from tale and showing it in pop up win