Home > Archive > PHP DB > July 2007 > Re: [PHP-DB] Slooooow query in MySQL.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PHP-DB] Slooooow query in MySQL.
|
|
|
| Rob Adams napsal(a):
> 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.
60k rows is not that much, I have tables with 500k rows and queries are
running smoothly.
Anyway we cannot help you if you do not post:
1. "show create table"
2. result of "explain query"
3. the query itself
OKi98
| |
| Aleksandar Vojnovic 2007-07-20, 7:58 am |
| 60k records shouldn't be a problem. Show us the query you're making and
the table structure.
OKi98 wrote:
> Rob Adams napsal(a):
> 60k rows is not that much, I have tables with 500k rows and queries
> are running smoothly.
>
> Anyway we cannot help you if you do not post:
> 1. "show create table"
> 2. result of "explain query"
> 3. the query itself
>
> OKi98
>
|
|
|
|
|