|
|
Posted by Jerry Stuckle on 06/23/07 02:11
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.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|