Re: how to handle 6 million Records in MY Sql???

[jignesh adeshara]

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