Subject Re: [firebird-support] optimizing embedded server
Author Todd Fisher
On Tue, 25 Jan 2005 10:08:02 +1100, Alan McDonald <alan@...> wrote:
>
> > Hi,
> > I'm writing an application that embeds firebird using it for a
> > application database. Following the embedding howto for win32
> > basically, this just means copying the fbembed.dll to fbclient.dll
> >
> > I'm noticing that my application hits the file system a lot and am
> > wondering if there is a setting to force the database to keep more of
> > it's data in memory, reducing the disk i/o.
> >
> > thanks,
> >
> > Todd
>
> 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