From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
Sent: Wednesday, October 15, 2008 1:54 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Data Loss in Windows Vista



--- In firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com> , "bogdan" <bogdan@...> wrote:

>
> > Database header page information:
> > Flags 0
> > Checksum 12345
> > Generation 84490
> > Page size 4096
> > ODS version 10.1
> > Oldest transaction 81692
> > Oldest active 84481
> > Oldest snapshot 84481
> > Next transaction 84482
> > Bumped transaction 1
> > Sequence number 0
> > Next attachment ID 0
> > Implementation ID 16
> > Shadow count 0
> > Page buffers 0
> > Next header page 0
> > Database dialect 3
> > Creation date Feb 8, 2008 9:00:35
> > Attributes force write, no reserve
> >
>
> >I give in,... what's 'no reserve'
> >Alan
>
> AFAIK - it is used for systems with limited amount of space available.

Whilst it could be employed to conserve disk space, it is normally
only used for read only databases because there is no point setting
aside room for updated records if it is impossible to update records.

> Pages are filled near 100%.
>
> Never to use for production databases.
> Data loading is extremely slow

>Probably the other way around. Loading speed would be quicker if
>anything because there would be less pages to read from disk, but the
>moment you go to update a record the engine has to set up and possibly
>request from the OS space for a new data page.
>
>Adam

Hi

I've tried it once (about 8 years ago) - it was an old version of Firebird
and it filled database cca 20 times slower,
so i've never try it again

Bogdan





No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.173 / Virus Database: 270.8.0/1725 - Release Date: 14.10.2008
21:25



[Non-text portions of this message have been removed]