Re: [PHP-DB] speeing up query and display...

2003-07-21 Thread colbey
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 mu

RE: [PHP-DB] speeing up query and display...

2003-07-21 Thread Aaron Wolski
e: [PHP-DB] 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: > > > $manufQuery

Re: [PHP-DB] speeing up query and display...

2003-07-20 Thread John W. Holmes
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: $manufQuery = db_query("SELECT manufacturer FROM kcs_threads"); while ($manufResults =

Re: [PHP-DB] speeing up query and display...

2003-07-19 Thread Becoming Digital
I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWTYUU - Original Message - From: "Aaron Wolski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, 19 July, 2003 13:29 Subject: [PHP-DB] speeing up query and display... Hi Guys, I have th

[PHP-DB] speeing up query and display...

2003-07-19 Thread Aaron Wolski
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: > Can ANYONE see a way to speed up the query and displaying of the results? Take a while on High Spe