[Xapian-discuss] inmemory database

[Bobo Wieland]

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
>