] speeing up query and display...
Aaron Wolski wrote:
Hi Guys,
I have the following query which unfortunately has to grab all records
in a table (well over 3000) to display in a multiple select box.
Code:
?php
$manufQuery = db_query(SELECT manufacturer FROM
A bit offtopic .. But 3000 X any kind of size = a good amount of rendered
html data to be transmitted.. I'd make sure your using some kind of
compression module on the server like mod_gzip ... that would cut down on
download time dramatically (Especially for low bandwidth users)
3000 rows isn't
Aaron Wolski wrote:
Hi Guys,
I have the following query which unfortunately has to grab all records
in a table (well over 3000) to display in a multiple select box.
Code:
?php
$manufQuery = db_query(SELECT manufacturer FROM
kcs_threads);
while ($manufResults
You've got three queries, two of which are in while loops. If you're calling up
3000 records, you may have as many as 3000 DB queries, possibly more. That's
why things take forever.
Restructure your code, placing the queries outside the loops. Then use
mysql_fetch_array() and loop through the
