MySQL Forums
Forum List  »  Performance

Re: how to handle 6 million Records in MY Sql???
Posted by: jignesh adeshara
Date: February 11, 2005 05:24AM

Hi
Thankx for replying,

let me explain my problem

i have one table named books, which contains 6 million records, i am providing searches on 4 fields:
1) by isbn 2) by title 3) by author 4) by category

now as table contains 6 million records, it takes too much time to search records from this table. even i created indexs on above 4 fields, but as indexes are created in same table so it slow downs the searching speed.

so i copied these table 3 times, 1 for isbn search, 1 for title search 1 for category search and created 1 index on each table.

now my query is like this:
Select * from books where title like "%america%";

as there are 6 million records this query takes too much time (more then 5 min.!!) to execute even for a single user. so how can i make fast search for this query?

is there any limitations for MySQL to handle records? or i have to switch on to different technology then MySQL.

Jignesh Adeshara

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to handle 6 million Records in MY Sql???
2717
February 11, 2005 05:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.