You can increase the number of pages kept in memory. This will improve
read performance.

-----Original Message-----
From: Todd Fisher [mailto:todd.fisher@...]
Sent: Tuesday, January 25, 2005 2:34 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] optimizing embedded server


On Tue, 25 Jan 2005 16:06:07 +1100, Alan McDonald <alan@...>
wrote:

>
> > > would you really want to do that even if you could?
> > > On windows we all talk about setting databases forced writes
> > to ON for the
> > > sake of safety.
> > > What is the setting of the database in question?
> > > If you are brave enough, perhaps this setting works with

embedded too.

> > > I don't think I'd try it though. Too much chance in the mebedded
> > > environment
> > > to have your database go awol.
> > > Alan
> > [snip]
> >
> > I'm having trouble understanding... I'm wondering if there are

some

> > configuration options I can pass to the database to improve it's
> > peformance on systems that have slow disk speeds.
> >
> > thanks,
> >
> > todd
> 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.



Yahoo! Groups Links