Why is this script so slow?

"J.O. Aho" <user@example.net> wrote in message
news:566v71F27f0duU1@mid.individual.net...
> kenoli wrote:
> > The following code is extracting all fields from all records from a
> > mysql database that has about 250 records in it.
>
> Getting so much data into a page at one time makes it more difficult to
get a
> good overview of things, maybe you should split up things into 20 rows per
> page with a small neat little "next" and "previous" buttons.


I'd probably try that route also. You can append something like " LIMIT 20"
to your query and at least get a gauge of the time it takes to retrieve and
process 20 results. Someone else had also suggested adding timers through
the script, so you can get a better idea if the slowdown is with the SQL or
the HTML displaying in your web browsers.

Tom
--
Newsguy.com - Basic Accounts $39.95 / 12 months


>
> > Firefox takes over
> > one minute to extract these records and display them in rows in a
> > table using the code included below. Safari takes about 30 seconds.
> > Even after the page displays, the scrolling is a little eratic.
>
> In firefox go to:
> about:config
> toggle the value for network.dns.disableIPv6 so it says true.
>
>
>
> --
>
> //Aho