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> build <OPTION> stmt
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
Richard mailto:[EMAIL PROTECTED]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php