Re: Can anyone help speed this up??

[Felix Geerinckx]

Bruce D wrote:

> Here's the breakdown:
> MySQL 4.0.12
> Table: Assignment (indexes are created on proper fields) 419,234 records
> Table: Finders (indexes are created on proper fields) 5,345,657 records

> My user wants to be able to do a wild card search on lastname in the finders
> table. So, I wrote the following query.

Could you post the result of EXPLAIN SELECT ... \G

as well as the output of

SHOW INDEX Finders \G
SHOW INDEX Assignment\G


Did you run

ANALYZE TABLE

on your tables?

Are you using MyISAM or InnoDB?

--
felix
Please use BBCode to format your messages in this forum.