Re: Multiple Databases - Search and retrieve.

[Saurabh Arora]

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.