Java EE (Java Enterprise Edition) General Discussion

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

I am returning about 1000 rows from a SQL Server which resides in the mid-west. Client PCs are located on the East Coast. These 1000 rows are placed into an HTML table with about 8 different columns and different colors.

I am trying to find out where is it that is slow, taking about 14 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 JSPWriter to create an out object to 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.

Ivan