Skip navigation links

MySQL Forums :: Full-Text Search :: Multiple Databases - Search and retrieve.


Advanced 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.

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.

Options: ReplyQuote


Subject Views Written By Posted
Multiple Databases - Search and retrieve. 4027 Saurabh Arora 07/08/2011 06:35AM
Re: Multiple Databases - Search and retrieve. 1567 Rick James 07/09/2011 04:25PM
Re: Multiple Databases - Search and retrieve. 1329 Saurabh Arora 07/11/2011 03:11AM
Re: Multiple Databases - Search and retrieve. 1474 Rick James 07/11/2011 11:26AM
Re: Multiple Databases - Search and retrieve. 1222 Saurabh Arora 07/11/2011 12:28PM
Re: Multiple Databases - Search and retrieve. 2122 Rick James 07/12/2011 12:23AM
Re: Multiple Databases - Search and retrieve. 1328 Saurabh Arora 07/12/2011 12:53AM
Re: Multiple Databases - Search and retrieve. 1452 Rick James 07/12/2011 10:02PM
Re: Multiple Databases - Search and retrieve. 1235 Saurabh Arora 07/14/2011 03:27AM
Re: Multiple Databases - Search and retrieve. 1928 Rick James 07/14/2011 09:46AM


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.