Xref: alice comp.databases.oracle.misc:19707
Path: alice!news-feed.fnsi.net!newsfeed.wli.net!newshub.northeast.verio.net!news3.cac.psu.edu!zeus.hrb.com!usenet@icf.hrb.com
From: Kevin Kirkpatrick <kjk@hrb.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: HTML Tables to display data
Date: Wed, 09 Sep 1998 13:51:19 -0400
Organization: Raytheon Systems Company
Lines: 49
Message-ID: <35F6C017.16A37054@hrb.com>
References: <35F59CC5.294FB19E@hrb.com> <35f6523d.31343229@dcsun4.us.oracle.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.05 [en] (WinNT; U)
To: clbeck@us.oracle.com

That seemed to drastically speed up the loading of the page.  I used a
conditional statement that was triggered every 20 rows of data, then I
printed the </table><table>.  I was very happy with the load time, but I ran
into another problem and this one I am at the mercy of Netscape.  The tables
are all different dimensions depending on the data that is inside of the
cells.  I tried to use WIDTH to predefine the cells, but it was no good.  I
wished that there was a way in HTML to say 'I want this in that column#'
These html tables change depending on the data within, there is no way to
hardcode them so that they never change no matter what the data looks like.
Or atleast, I haven't found a way to combat this.  Do you or anyone else know
how to resolve this problem with HTML?

Christopher Beck wrote:

> 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
> >