Subject | Re: [firebird-support] Re: firebird on virtual server |
---|---|
Author | Kjell Rilbe |
Post date | 2010-10-19T10:30:56Z |
Lester Caine skriver:
each transaction commit. The disk head does a huge amount of
buzzing/rumbling for each commit. Haven't experienced that with
PostgreSQL or SQL Server, which are both MGA aren't they?
So why doesn Firebird behave like this and how can we configure it to
make it lose less time on disk seeks?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
> Actually the question you need to ask is 'does the VM actually write to theOf course! But I've always wondered why Firebird does so many seeks for
> disk?' I still need to be convinced that VM is a safe way of handling
> important
> data ... when ideally Firebird needs to get direct to a the real disk :)
> Caching
> seems to come into play with a lot of 'speed-up' options, but that is
> the last
> thing you want with any database write?
each transaction commit. The disk head does a huge amount of
buzzing/rumbling for each commit. Haven't experienced that with
PostgreSQL or SQL Server, which are both MGA aren't they?
So why doesn Firebird behave like this and how can we configure it to
make it lose less time on disk seeks?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64