I seem to have fixed it with a backup (using -g switch) and restore.

Is there any way of stopping this happen in the future?

Thanks for all the help.

Regards,

Ben

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:
>
> > I don't seem to be anywhere near swapping at the moment. I've
got
> > 500,000k physical memory free. What's the best way to cache
more
> > data in Firebird?
> >
>
> Firebird.conf lets you set the number of pages to cache. You need
to
> restart the service for it to take effect. Changing the page size
of
> the database will also obviously cause it to use more. Be careful
if
> you are switching to classic though. You should use a much smaller
> cache if switching to classic server as each connection creates a
> service instance.
>
> > >
> > > >
> > > > Is there anything else I can do? Is it worth me upgrading
to FB
> > > > 1.5.4? Or even 2.0.1?
> > >
> > > 1.5.4, definately (but not for performance reasons, it is a
> > > maintenance release for bugs etc). 2.0.1 should generally give
> > better
> > > performance both with a better optimiser and smarter garbage
> > > collection, but may be more of an effort if you have bad SQL
in
> > some
> > > queries.
> >
> > Is upgrading to 1.5.4 as easy as stopping the server and running
the
> > install file? What else do I need to take into account?
>
> Pretty much. I would uninstall first if changing between
Superserver
> and classic.
>
> Adam
>