How much memory are we talking for keeping the database I use in RAM?
Quoting myself: "I'm going to index perhaps 3,000,000 records from a
mysqldatabase. None of the records holds any large textdata. It is
mostly names and numbers. The database grows by approx 400,000 records
a year."
mvh
Bobo Wieland - Kodstationen AB
-------------------------------------------------
Kodstationen AB
J?rnv?gsstationen
262 52 ?ngelholm
-------------------------------------------------
Tel: 0735 - 880 100
E-post: bobo at kodlabbet.se
-------------------------------------------------
Detta e-mail skickades via SilverCRM
http://www.silvercrm.se
Olly Betts <olly at survex.com> skrev:>On Fri, Sep 19, 2008 at 11:52:32AM +0200, Bobo Wieland wrote:
>> Would it work to use the inmemory database type to speed up
searches>> - or is it a bad idea?
>
>I wouldn't recommend the inmemory database for large-scale use at
>present - it's not been written with such use in mind. If you have
>plenty of memory, you'll keep the disk based database in RAM anyway.
>
>The long term plan is to replace inmemory with the disk-based
backend>but working out of memory rather than disk.
>
>Cheers,
> Olly
>