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. 4035 Saurabh Arora 07/08/2011 06:35AM
Re: Multiple Databases - Search and retrieve. 1575 Rick James 07/09/2011 04:25PM
Re: Multiple Databases - Search and retrieve. 1340 Saurabh Arora 07/11/2011 03:11AM
Re: Multiple Databases - Search and retrieve. 1483 Rick James 07/11/2011 11:26AM
Re: Multiple Databases - Search and retrieve. 1229 Saurabh Arora 07/11/2011 12:28PM
Re: Multiple Databases - Search and retrieve. 2133 Rick James 07/12/2011 12:23AM
Re: Multiple Databases - Search and retrieve. 1336 Saurabh Arora 07/12/2011 12:53AM
Re: Multiple Databases - Search and retrieve. 1458 Rick James 07/12/2011 10:02PM
Re: Multiple Databases - Search and retrieve. 1242 Saurabh Arora 07/14/2011 03:27AM
Re: Multiple Databases - Search and retrieve. 1935 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.