MySQL Forums
Forum List  »  Full-Text Search

Re: Multiple Databases - Search and retrieve.
Posted by: Rick James
Date: July 12, 2011 10:02PM

> My webspace provider, is offering me unlimited DBs but these can only have size of 1GB each.
Strange limitation. He does mean "database" and not "table", correct?

What is your rough calculation of the space you need?

Consider compressing the text parts of the articles -- this will shrink English (at least) by about a factor of 3.

However, compression would prevent the use of FULLTEXT.

FULLTEXT indexes are often bigger than the uncompressed text that it is indexing.

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.

Caveat: the "relevance" (if you are thinking of using that) in one table does not compare to the relevance in another table. That is, this won't be meaningful:
(
SELECT ... MATCH... as relevance FROM db1.tbl WHERE MATCH ...
UNION ALL
SELECT ... MATCH... as relevance FROM db2.tbl WHERE MATCH ...
) ORDER BY relevance DESC

Consider getting another hosting service; it might be simpler.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Multiple Databases - Search and retrieve.
2110
July 12, 2011 10:02PM


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.