Hello Robin,
Sunday, December 21, 2003, 10:15:35 PM, you wrote:
RK> The code I am using is thus and is retrieving around 2,500 records:
RK> $result = mysql_query($sql)
RK> while ($row = mysql_fetch_array($result))
RK> {
RK> build <OPTION> stmt
RK> }
You're building a select list of 2500 elements? No wonder it's slow.
That must be generating a few hundred KB's worth of HTML on its own,
let alone anything else on the page.
If you're not using all 2500 rows, you need to optimise your query to
reflect this.
--
Best regards,
Richard mailto:rich@xxxxxxxxxxxxxxxx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
