| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Duncan Hill | Date: | November 27 2006 2:37pm |
| Subject: | Re: Performance Problems With Two Tables With Over 500K Rows | ||
| View as plain text | |||
On Saturday 25 November 2006 17:54, John Kopanas wrote: > The following query takes over 6 seconds: > SELECT * FROM purchased_services WHERE (purchased_services.company_id = > 535263) What does EXPLAIN say about that query? Have you done an optimize recently? -- Scanned by iCritical.