MySQL Forums
Forum List  »  Full-Text Search

Relatively large database.. search takes a verry long time
Posted by: Rika Venturiano
Date: May 29, 2008 08:48PM

I have a pretty large database (about 5 gb) and most of it is text, I added a fulltext index and changed the select from like to match but it still takes a long time to search (several minutes) for just one user, I dont even want to think of the situation where several users are searching at the same time.

The database is destinated only for selects.. no updates are made so my question would be: is there a way to put the entire database into ram, like on a ramdisk and if so, what system would I need, now Im using suse linux with 2gb of ram, could I instal a high enough amount of ram to be able to create a ramdisk large enough (6gb) so that the entire db would fit on it?


Edited 1 time(s). Last edit at 05/29/2008 08:48PM by Rika Venturiano.

Options: ReplyQuote

Written By
Relatively large database.. search takes a verry long time
May 29, 2008 08:48PM

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.