At 23/07/2002 04:27 PM, you wrote:

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

Windows 2000 doesn't have it. The other issue that I've found could be the
anti-virus software that could be scanning the file.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)