Subject RE: [firebird-support] Re: Is there transaction logging in FireBird?
Author Alan McDonald
> Alan/Adam,
>
> Thank you for the info.
>
> So I guess 'bulk loading' is not an option in
> Firebird?
>
> Vlad

INSERT INTO INTERNALTABLE (SELECT * FROM EXTERNALTABLE)
is the fastest way I know
Alan

>
> --- Adam <s3057043@...> wrote:
>
> > --- In firebird-support@yahoogroups.com, Vlad
> > Orlovsky <vmo3d@...> wrote:
> > >
> > > Hi Everyone,
> > >
> > > I'm using embedded Firebird for my .NET 2.0
> > project
> > > and was wondering if there is a 'transaction log'
> > that
> > > is kept inside the .fdb file?
> > >
> >
> > There is no explicit transaction log as with other
> > databases. The
> > different versions of the record are kept in the
> > database against the
> > respective recods. This means that there is an
> > instant recovery in the
> > case that a database crashes, not a slow recovery
> > process.
> >