Re: Multiple Databases - Search and retrieve.

[Saurabh Arora]

Thanks Rick, for your valuable time.

I decided to split up data into many DBs as it makes logical sense. Secondly, with time the number of rows in each table in each category shall increase exponentially, so i am thinking....

tell me if this is the right approach to have a DB structure -

For a few(say 7) related DBs, i can have 1 DB(as you suggested), which shall have - a TEXT field with a FULLTEXT index, and an id.
In full text index i can combine data of 3 coloums to search faster.
In unique ID - i shall have DBName, tblname and Row ID which will give me the exact location of it.

so if i have 49 DBs i shall have 7 indexed dbs to search my content into.

2.

Also, what is best way to get the data of first 15 records and the total row count. (using limit(15) and sql_calc_found_rows in the same querry)
or to use count(*) --> is it okay if I do it like this..

SELECT SQL_CALC_FOUND_ROWS name, email FROM users WHERE name LIKE 'a%' LIMIT 10;
SELECT FOUND_ROWS();

(Table Users id indexed), then i will have to go to actual table and fetch all the records

Thanks
Saurabh.