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
> >
>