RE: [bdbxml] recommended cache size

> We're working on fine tuning the performance on our DB XML
> application, and we were wondering what a recommended cache 
> size would be for the DB XML environment on a test machine 
> that has 1Gb of RAM? At the moment we use:
> 
> envConf.setCacheSize(67108864);
> 
> But this doesn't appear to increase performance/stop paging to 
> the disk, so I guess this should be increased?

Anthony, 

Cache size and query performance are more a function of the size 
of your repository, your data access patterns, the queries and
the available indices than the amount of memory available on your
system. 

The first question to ask is: How big is your XML repository? 

The second question is: Have you run db_stat -m to see how the 
existing cache is being utilized? For more information on 
db_stat, please see the documentation in your download package
or on our web site at: 
    http://www.sleepycat.com/xmldocs/utility/db_stat.html

Regards, 

Dave



------------------------------------------
To remove yourself from this list, send an
email to [email protected]