Hello,

For option 4, don't change it, its not significant and it could damage
your database if power failure / firebird abend.

Do you have an antivirus ?
If yes, try to exclude C:\Applications\Companies and fdb extension for
scanning.

Could you change vista performance settings and put services on high
priority ? instead of applications.

BTW, what application do you use to execute Insert ?

Regards

Alexandre

--- In firebird-support@yahoogroups.com, "bukobuko71" <radobukoci@...>
wrote:

>
>
> Hello again,
>
> thank you for your hints:
>
> 1. File is C:\Applications\Companies\CNS.FDB
> System restore is off, for all drives.
> 2. Connection string: was localhost, changed to 127.0.0.1, no

speed-up

> (from second machine it was 10.0.0.4, the same slowness)
> 3. Tried to turn off the firewall, no speed-up
> 4. Sorry I didn't try Forced Writes OFF, maybe later.
>
> Another funny thing is the mentioned INSERT statement takes once 1
> second, another time 4 seconds, another time even 19 seconds.
>
> May it be some bad set-up of Vista itself?
>
> Thanks, Rado
>
>
>
> --- In firebird-support@yahoogroups.com, "amoradell" <amoradell@>
> wrote:
> >
> > Hello,
> >
> > 1 - what is the extension ? gdb ? system restore on ?
> > 2 - connection string : localhost, other host name ? try 127.0.0.1
> > 3 - firewall on vista : try disabled
> > 4 - database with forced writes : try off
> >
> > Regards
> >
> > Alexandre
> >
> > --- In firebird-support@yahoogroups.com, "bukobuko71" <rado@> wrote:
> > >
> > > Hello all,
> > >
> > > I have a problem with FB 2.0.3 on Vista Home Edition. I try to run a
> > > statement like
> > >
> > > INSERT INTO Table1 (ID) SELECT ID FROM Table2;
> > >
> > > This inserts app. 2000 rows into Table1.
> > >
> > > I ran this statement on the same DB on three machines with following
> > > execution times:
> > >
> > > - Linux: 0.02 s
> > > - Windows XP: 0.02s
> > > - Windows Vista: 4 s (200 times more, and disk is working

during the

> > > statement)
> > >
> > > I was reading newsgroups, FB manuals and googling for long time but
> > > did not find anything helpful, so I am posting here. Please help.
> > Thanks.
> > >
> > > Rado
> > >
> >
>