At 03:15 PM 12/21/2003 -0700, Robin Kopetzky wrote:
Good afternoon!

I am writing a project and have a speed concern...

The code I am using is thus and is retrieving around 2,500 records:

        $result = mysql_query($sql)
        while ($row = mysql_fetch_array($result))
                build <OPTION> stmt

        Is there a faster method? Timed this with microtime and .9 seconds to
retrieve the data and output the web page seems REAL slow. Now this is on a
T-Base-100 network but I imagine it would be like watching paint dry in a
56K modem. Any thoughts, ideas on accelerating this? I did try ob_start()
and ob_end_flush() and no help...

Thank for any help in advance.

Robin 'Sparky' Kopetzky
Black Mesa Computers/Internet Service
Grants, NM 87020


That's a huge option list. Just from the point of view of the user it is too large. Is there any way you can pare it down?

MySQL will select those records really quickly, but then the HTML has to be generated and the broser has to render the list. Try and rethink this if you can.

Regards - Miles Thompson

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to