You are here: Re: Why is this script so slow? « All PHP « IT news, forums, messages
Re: Why is this script so slow?

Posted by Jeff North on 03/19/07 00:41

On 18 Mar 2007 14:10:18 -0700, in alt.php "kenoli"
<kenoli.p@gmail.com>
<1174252218.374723.246040@d57g2000hsg.googlegroups.com> wrote:

>| The following code is extracting all fields from all records from a
>| mysql database that has about 250 records in it. 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.
>|
>| When I use another script to extract the same data and display the
>| first and last names in one column, it takes about 3 seconds from
>| start to finish. So I believe it is not the database or the server.
>| I can only conclude it is the script.
>|
>| I pulled as much html our of print(), echo() and heredoc commands as
>| possible. I had suspected the "if" conditionals that set the check
>| boxes as checked or not and tried various options here like setting
>| these values to variables and inserting the variables into the html
>| instead of the whole statement and even removing them altogether and
>| nothing changed.
>|
>| I've used the same select/option code in other scripts that work fine.
>|
>| Help. What is my problem?
>|
>| Thanks,
>|
>| --Kenoli
>|
>| I've included the query and the while loop that creates the table rows
>| of concern.
>|
>| If you want to see it operate in real time, you can try it out here:
>|
>| http://sfnan.org/nandb/pages/lookup_results.php?all=all
>|
>| It's not live data.

Apart from the 2,250 errors that http://validator.w3.org picked out
the most obvious one is
<input type="hidden" name="id[]" value="{$row['person_id']}">
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация