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 14, 2011 03:27AM

OK.. great.

I have been researching & I am starting to see the full picture now, of how it otta wrk :)

Loads of thanks to you RICK. You are simply awesome.


And i still have loads of doubts :)) HOORRAAAYYYYY...!!

ok...

1.

I dnt wanna change my host company(Though i still formally have to buy the space, want to finish as much development before buying)-- GoDaddy.com -- taking linux ultimate plan which gives unlimited databases of 1GB. Still if you know any better hosting service please recommend, I shall definitely take a look at what they are offering.

2.
The Length of each row shall be close to VARCHAR(700) out of which 400 shall be for description, on which i do not need fulltext. so i can compress this field.
Shall need more help on it.

3.
How much space in a table a FULLTEXT(COL1, COL2, COL3, COL4) need if all the columns combined are of size Varchar(200).
I could not figure out the space requirements of FULLTEXT and where these are stored and how?. Please explain or suggest a book/article.

4.
You suggested -->>

"
So, let's say you have to have several GB of FULLTEXT indexes.
SELECT ... FROM db1.tbl WHERE MATCH ...
UNION ALL
SELECT ... FROM db2.tbl WHERE MATCH ...
UNION ALL
SELECT ... FROM db3.tbl WHERE MATCH ...
...
would be the way to search them all in one pass.
"

Excellent, but i just want the fields for first 15 results and approx row count for the rest.
As, i want to implement pagination.
Please suggest the most optimized method to do it.

And once again thank you for your valuable time, RICK. i really really apperitiate it.

Thanks
Saurabh.

Options: ReplyQuote


Subject Views Written By Posted
Multiple Databases - Search and retrieve. 3899 Saurabh Arora 07/08/2011 06:35AM
Re: Multiple Databases - Search and retrieve. 1512 Rick James 07/09/2011 04:25PM
Re: Multiple Databases - Search and retrieve. 1275 Saurabh Arora 07/11/2011 03:11AM
Re: Multiple Databases - Search and retrieve. 1422 Rick James 07/11/2011 11:26AM
Re: Multiple Databases - Search and retrieve. 1170 Saurabh Arora 07/11/2011 12:28PM
Re: Multiple Databases - Search and retrieve. 2062 Rick James 07/12/2011 12:23AM
Re: Multiple Databases - Search and retrieve. 1268 Saurabh Arora 07/12/2011 12:53AM
Re: Multiple Databases - Search and retrieve. 1400 Rick James 07/12/2011 10:02PM
Re: Multiple Databases - Search and retrieve. 1182 Saurabh Arora 07/14/2011 03:27AM
Re: Multiple Databases - Search and retrieve. 1874 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.