In the last episode (Dec 10), Aaron said:
> The query below takes around 8 seconds, and returns 3253 rows.
>
> Query:SELECT ID FROM Offers_To_Buy FORCE INDEX(scdd) WHERE subcatID = 72;
> 3253 rows in set (8.00 sec)
>
> Explain says:
Bad word-wrapping fixed:
> mysql> EXPLAIN SELECT ID FROM Of
3. Why so many indexes? Do you search on every one of those fields? If
not, then you are probably wasting diskspace and speed.
Donny
> -Original Message-
> From: Aaron [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 10, 2004 8:12 PM
> To: [EMAIL PROTECTED]
> Subject: Wh
Have you tried optimizing or run an analyze table command on this table?
Aaron wrote:
Hi all ,
I have a relatively simple query that is taking longer than I think it
should. Can anyone possibly give me some idea why this might be or any
potential bottleneck areas I might want to check out?
thanks
Hi all ,
I have a relatively simple query that is taking longer than I think it
should. Can anyone possibly give me some idea why this might be or any
potential bottleneck areas I might want to check out?
thanks!
Here is some information.
The query below takes around 8 seconds, and return