Re: Fastest loop code/best way to get database results into array

On Mon, 2003-12-01 at 03:06, Galen wrote: > I'm working on some code that deals with a LOT of results from a MySQL > database and drops them into an array. It deals with about 17,200 > results on a very fast box in about 0.5 seconds, which is not too bad, > until I realize I may need to call it on about that many results > several times in a page. > > Is there any way to speed things up? Change to a different loop type? > Some other technique for pulling the data out of the database faster? > My only requirement is that the array format remain unchanged (yes, > associative values are important). > > Here's the code, which seems awfully simple: > > for($i=0; $i < $num_results; $i++) > { > $search_results[$i] = mysql_fetch_array($result, MYSQL_ASSOC); > } You might squeeze a little more speed by using the following: while( ($search_results[] = mysql_fetch_assoc( $result )) !== false ); array_pop( $search_results ); Cheers, Rob. -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------'