Xref: alice comp.databases.oracle.misc:19675
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!su-news-hub1.bbnplanet.com!su-news-feed1.bbnplanet.com!news.bbnplanet.com!inet16.us.oracle.com!not-for-mail
From: clbeck@us.oracle.com (Christopher Beck)
Newsgroups: comp.databases.oracle.misc
Subject: Re: HTML Tables to display data
Date: Wed, 09 Sep 1998 10:15:51 GMT
Organization: Oracle Corp.
Lines: 36
Message-ID: <35f6523d.31343229@dcsun4.us.oracle.com>
References: <35F59CC5.294FB19E@hrb.com>
Reply-To: clbeck@us.oracle.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 1.5/32.451

On Tue, 08 Sep 1998 17:08:22 -0400, Kevin Kirkpatrick <kjk@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
>