Dear,

Has anyone had experience with returning large sets of data to a dynamically built HTML table?

I am returning about 1000 rows from a ORACLE Server. These 1000 rows are placed into an HTML table with about 25 different columns.

I am trying to find out where is it that is slow, taking about 30 seconds for the table to display once the browser is launced. So far I think it is the actual rendering of the huge HTML table to the browser that is slow.

1) It is not SQL. Takes about 4 seconds execution time for my SQL statement to bring back 1000 rows. This should be acceptable given it has lots of conversions from datetime to varchar.

2) I am using Java Beans which generate the Dynamic HTML output to the JSPs.

3) I can tell from the print stack that the HTML table rows are being built fast. Between the completion of the HTML table and displaying to the browser, there is about a 7-8 second lag time. Is this the time the browser takes to render the HTML table?

Has anyone been through this before?

Thanks.

 

 

 

Reply

I am not sure about the reason, but I suppose you could use some profiler or debug statements to identify the bottleneck first.
After you know which part is taking up most of the 30 seconds, you can plan as to how to deal with it..

Cheers.

Reply