Subject Re: Vista performance problem
Author amoradell
I just read on

http://ibdeveloper.blogspot.com/2007/02/does-firebird-run-on-windows-vista.html

"When I'm not connected on network my firebird work fine, but, when I
connect on any network (and internet to) then program with firebird
database work realy slow."

So try to disconnect network cable, use 127.0.0.1 with firebird and if
you see improvement, its maybe a problem with vista network config.

found this :

http://www.chicagotech.net/vista/vistaslow.htm

Rgds

Alexandre


--- In firebird-support@yahoogroups.com, "amoradell" <amoradell@...>
wrote:
>
> 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
> > > >
> > >
> >
>