Subject Re: [firebird-support] Performance issue
Author Aage Johansen
Tetram Corp wrote:
> Hi,
>
> I'm facing a performance issue I'm not able to solve.
>
> Laptops are under Windows XP, with a FB1.5.4 installed on each one.
> Our application use IBO4.3 with a connection string like:
> 127.0.0.1:c:\etc\etc\db.fdb
> (So each application run in standalone context but not embedded)
>
> All works well..... except on one computer.
>
> With this computer, fetch time, execute time (even prepare time) are
> slower about 10 times. So, depending of the number of needed requests,
> some action in the application which should take about some ms, takes
> some seconds with this computer.
>
> This laptop is the newest we have.
>

Any particular differences in specifications?
Is RAM ok/enough/present?
No AntiVirus?
TCP/IP is fine, but could you try a local connection (remove
127.0.0.1: from the connect string)?
I don't know much about tcp/ip (or much else, for that matter), but
maybe the pc is wandering around on the www before checking the local
machine...
If you ping to/from this machine, does the timings seem ok?

--
Aage J.