Posted by Derrick Shields on 06/23/07 05:10

On Jun 22, 9:11 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> Derrick Shields wrote:
> > 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
>
> 11M rows isn't that big. Neither is 2.5 GB.
>
> But you're asking in the wrong group. This one is for PHP, not MySQL,
> and generally the MySQL experts don't hang out here. They hang out in
> comp.databases.mysql.
>
> Ask in the correct group and you will get a lot better answers.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================

Thanks for your help guys, I really appreciate it.

Jerry - I didn't actually know that group existed. I'll check it
out. I just did a simple google search and this group seemed to have
more active discussion of MySQL than anything else. Also, I'm a php
developer so I'll probably hang around.

Thanks again guys!

[Back to original message]