Re: Multiple Databases - Search and retrieve.
> 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.
Subject
Views
Written By
Posted
6935
July 08, 2011 06:35AM
2599
July 09, 2011 04:25PM
2357
July 11, 2011 03:11AM
2598
July 11, 2011 11:26AM
2171
July 11, 2011 12:28PM
3491
July 12, 2011 12:23AM
2273
July 12, 2011 12:53AM
Re: Multiple Databases - Search and retrieve.
2519
July 12, 2011 10:02PM
2236
July 14, 2011 03:27AM
2958
July 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.