I have an application that stores a large (up to 6gb) database in an InnoDB table. I'm using an InnoDB table to have concurrent inserts and selects and to get beyond the 2gb limitation.
I have to allow read-only remote database connections and cannot enforce that users use any kind of special query to access the database (e.g., implementing my own fulltext-like index and using the index at an application layer). The content consists of log entries which are each under 255 characters long. I'd like to know what I can do to improve the response time of the database under these restrictions. So I have a few questions: Would adding ram help? I can't imagine that an operation that requires searching 6gb (a disk bandwidth or processing bottleneck problem) would be improved much by adding ram.. ? Can I do anything (short of hardware changes) to increase performance? And long term question: I've noticed that a fulltext index feature doesn't appear on the InnoDB todo list. From my (limited) research, it looks like this is a feature a lot of people would find very useful. Is this a long term goal, or has it been excluded for some reason? Thanks Eric Mayers Software Engineer --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php