| Kevin Murphy 2007-07-19, 6:58 pm |
| Seeing the query would help.
Are you using sub-queries? I believe that those can make the time go
up exponentially.
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada College
www.wnc.edu
775-445-3326
P.S. Please note that my e-mail and website address have changed from
wncc.edu to wnc.edu.
On Jul 19, 2007, at 2:19 PM, Rob Adams wrote:
> I have a query that I run using mysql that returns about 60,000
> plus rows. It's been so large that I've just been testing it with a
> limit 0, 10000 (ten thousand) on the query. That used to take
> about 10 minutes to run, including processing time in PHP which
> spits out xml from the query. I decided to chunk the query down
> into 1,000 row increments, and tried that. The script processed
> 10,000 rows in 23 seconds! I was amazed! But unfortunately it
> takes quite a bit longer than 6*23 to process the 60,000 rows that
> way (1,000 at a time). It takes almost 8 minutes. I can't figure
> out why it takes so long, or how to make it faster. The data for
> 60,000 rows is about 120mb, so I would prefer not to use a
> temporary table. Any other suggestions? This is probably more a
> db issue than a php issue, but I thought I'd try here first.
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
|