• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How to increase speed while retrieving data from tale and showing it in pop up win

 
Ranch Hand
Posts: 151
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
In one form ,I have used f9 key to retrieve data from table in oracle database . i.e. in any input field in my form, once I press f9 key, it execute JavaScript windows. Open command.
In that command, I called the servlet which retrieves nearly 7000 rows data from table and then it dispatch request to another jsp page which shows the related data in tabular form. The data may contain nearly 7000-8000 rows.
So when I press the f9 keys it takes around 10-12 second to open the page.
Is there any ways to open this pop up windows within 2-3 second once I hit the f9 keys.
Here with I am attaching hole code for servlet and jsp page.
Any suggestion is highly appreciated.

Thanks and Regards
Harshal


jsp code

 
Ranch Hand
Posts: 1710
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Harshal,


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 ]
 
Harshal Gurav
Ranch Hand
Posts: 151
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Harshal Gurav
Ranch Hand
Posts: 151
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Can anyone have solution for above issue?

thanks and Regards
Harshal
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Harshal,
You said:


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.
reply
    Bookmark Topic Watch Topic
  • New Topic