Subject Re: [ib-support] FB slow, delay on W2k server
Author Achim Kalwa
florixhu wrote:

> following problem:
> (W2k server 256MB RAM, TokenRing Lan,
> FB1.0, Client access over BDE (TCP/IP),
> using stored procedures, gdb is ~100MB)
> when calling a complex stored procedure for retrieving data,
> always the first 20-30sec nothing seem to happen on the
> server (looking on taskmanagers process load).
> After this time process load of IB-server goes up as expected
> to 80-90% and returns then result set to client.

Just an idea: System file protection?
For a quick test rename the database file from .GDB to .FDB extension
(don't forget your client connect string).

Achim