Re: HTML Tables to display data

On Tue, 08 Sep 1998 17:08:22 -0400, Kevin Kirkpatrick <kjk_at_hrb.com> wrote:

>This question doesn't really relate to Oracle directly but I figure that
>many of you may have run into this problem. I am developing a Web
>interface to an Oracle database. One of the Oracle tables I am querying
>has over half a million rows of data. My problem is that when I go to
>query the table, it is very possible for the result to be 500+ rows of
>data if not more. I used HTML tables to print out the data but Netscape
>practically chokes when it tries to create it, it takes forever. Is
>there some other way that I can display this large amount of data but
>still maintain that column format? Another way to avoid <TABLE>?
>

The reason Netscape takes a long time is that it need to determine the table column sizes and that can not be done until it gets the last row. I have tried two different ways to avoid the long load problem. Each works fine for different situations.

1. Open the HTML table and columns with specific sizes. Then after about 20-30 rows close the table and open another one with the same size. Netscape will then be able to draw many smaller tables faster or at least it appears faster since the first table appears quickly.
2. Do the formatting yourself and stick the whole thing inside <pre></pre> tags.

chris.

>Thanks in advance...
> Kevin
>
Received on Wed Sep 09 1998 - 05:15:51 CDT