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. |
`------------------------------------------------------------'
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
