MySQL Forums
Forum List  »  Full-Text Search

Re: Multiple Databases - Search and retrieve.
Posted by: Saurabh Arora
Date: July 11, 2011 03:11AM

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.


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;

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


Options: ReplyQuote

Written By
Re: Multiple Databases - Search and retrieve.
July 11, 2011 03:11AM

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.