At 08:00 AM 20/06/2003 +0700, you wrote:

> > Hi All,
> >
> > I Just tried windows server 2003. I found that my interbase server
> > performance slow down on this platform on everytime connect to database.
> > it's take long time before the server reply request from the client.
>There's
> > any tricks I've miss ?

There is a "feature" in XP called SystemRestore, that targets files with
the suffix ".gdb" and performs a filesystem-level backup on them each time
the file is opened.

You can't disable the "gdb" target from SystemRestore's built-in list
(well, you can, but it keeps coming back) but you can work around the
problem by either 1) placing your "gdb" files on a partition that SR is
instructed to ignore; or 2) renaming your primary database files with a
different extension, e.g. ".ib".

This is the most likely cause.

Another possibility, if your server box is SMP, is that you are using a
version of IB that doesn't support SMP on Windows platforms. I believe IB
7 is the only version that claims to do so. The fix for this depends on
what version of IB you are running - pre-IB 6.5 requires you to install the
server to run as an application, and to use the ib_affinity tool (free) to
set the processor affinity to one specific CP. IB 6.5 allows you to
configure the affinity for the service, via the ibconfig file - I think the
parameter is called cpu_affinity.

hth
heLen