Hi,

At January 25, 2005, 15:33, Todd Fisher wrote:

> On Tue, 25 Jan 2005 16:06:07 +1100, Alan McDonald <alan@...> wrote:
>> not that I know of. how much writing are you doing? It could be an
>> application issue and not a database (server) issue. Are you doing bulk
>> inserts?
>> Alan

> Yes i know I could change the structure of my application, but I was
> mostly interested in finding out whether or not there are any
> configuration options that can be past to the database to optimize it
> for applications that run on older systems with poor hard drive
> performance.

You can increase the database cache, but it will not increase the
performance of reading the data pages from the hard drive. That being
said, the cache size will also depend on the available memory. In
example, if the system only has 128MB and running Windows 2000, a
10,000 page cache of 8KB pages will be too high, because Windows will
be paging memory to disk anyway and that will defeat the purpose of
increasing the database cache to increase performance.


--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)