Subject Re: [IBO] Write performance with Vista
Author henry FRANQUET
--- In IBObjects@yahoogroups.com, Geoff Worboys <geoff@...> wrote:
>
> Hi Henry,
>
> > I have an app with Delphi 5 and IBObject 4.5 (an old version).
> > With IB_Pump I have very slow performance on Vista (100 times
> > slower than on XP Pro)
> > When using and enabling TIB_Monitor (with or without setting
> > OnMonitorOutputItem) the performance is correct
>
> > Have you any idea on how to get good performance without enabling
> > IB_Monitor ?
>
> What version of Firebird? (v1 or v2, classic or superserver).
> Are you connecting to the same FB server for both connections?
>
> I know of an issue with FB v1.5 superserver where such transfer
> processes will seem to pause at intervals (and can be restarted
> by having any sort of activity at all to the same server).
> The effects and timing of the pauses are highly variable (seems
> to partly depend on row sizes and column types). The dramatic
> change you describe seems similar, wondering if perhaps Vista
> makes the problem more obvious.
>
> If you are using superserver v1.5 or earlier try classic. I
> believe the problem is supposed to be fixed in v2 but I am
> in the process of migrating so cannot confirm.
>
> --
> Geoff Worboys
> Telesis Computing
>
Hi,
Yes I use Firebird 1.5.5 in SuperServer Mode and both connections are
on the same server. The timing of the pauses are effectively extremely
variable, I don't have the same timing when I retry the job without
stopping the programme.
The processor is a dual core, but I have run this app on dual-core on
XP pro without having loss of performance. I'm aware of the problem
with hyperthreading on Xeon servers and I always use Classic version
of Firebird on it
I'll try both suggestions, setting affinity and using Classic version
of Firebird with that CPU.

Thanks a lot
Henry