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

Any time you put 2500 elements into a SELECT box, it's going to be slow. The browser is going to take a noticable time rendering that box.

Are you actually building the <option> list up in a variable before displaying it or just echoing it outright? Building the whole thing up into a variable will take longer than just echoing it directly to the browser.

Other than that, if you're not willing to change your UI so you don't have a 2500 element select box, there's not much you can do.

---John Holmes...

Amazon Wishlist:

php|architect: The Magazine for PHP Professionals –

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to