Posted by Derrick Shields on 06/22/07 15:28

I'm working with a database that has over 11 million rows. The .SQL
drop file is about 2.5gigs. Doing a simple query:

select * from people where last_name like '%smith%'

A query like this can take up to two minutes. I've spent hours reading
these forums and other sites on the internet, and I've figured that I
need to do a couple things:

create some indexes -and- possibly create some partitions

One thing I couldn't figure out though is what order to do these
things. Is creating partitions even necessary? Also, I tried creating
indexes on first_name and last_name columns, and it seems like it's
just freezing. It sat there for hours and never responded. Is the
database getting too big at this point to create indexes?

Thanks for any help anyone can offer!

Derrick

• Next in forum: Re: At what point should I implement validation?
• Prev in forum: Re: Parsing a php include (which also contains php code) - or "Reparsing" the php file
• Thread view: MySQL: 11 Mil Rows = Slow Performance!

[Reply to this message]