Hi Matijn,

Sorry you got lumbered with the "everything must be free otherwise you are
the anti-Christ" flame, very tolerant of you, I think I would have been less
humane.

The live server is running BDE apps and replication, so the TX diffs can get
pretty high, but the test servers that exhibit the same are run from fresh
and exhibit the performance differences after just a few minutes, so I'm
guessing not. As I said, I haven't been on site, so I haven't been able to
have a very good look, hoping to do that on Friday.

I was hoping to pick up a couple of gems like:
A new thread is spawned when a client is waiting for a query to be executed
or when the server is waiting to send results back. Because of the home
grown threading in 5.6 I am assuming that threads are implemented on the
periphery, e.g. server side remote connection handler, rather than low level
VIO / Execution / Planning etc.

They have been running on the old server for years, running hot mind as the
load is pretty heavy and it is BDE.

I'll do some more digging on Friday, but any help on why, how and when
threads are created / destroyed in IB would be of help.

Cheers,

JAC.



""Martijn Tonies"" <m.tonies@...> wrote in message
news:005601c2bccb$2f3f5d60$0a02a8c0@seal...

> Hi,
>
> > I have a client that is having problems with a new server, they are
> trying
> > to improve performance on a system temporarily (their actual aim is to
> eval
> > FB 1 / IB 7). Their old server is dual proc 800 MHZ PIII with 1GB RAM

OS

> /
> > swap and temp on mirrored, data on 5 disk raid. New server is 2.2Ghz

PIII

> > with 2GB RAM and same disk config (except disks spin 2x old disk speed.
> >
> > The new server starts off being a lot quicker, but performance degrades

as

> > load increases during the day. They are doing all kinds of

observational

> > testing and have noticed that under heavy load the IB process' No of
> threads
> > jumps between 20 -> 240.
>
> What are the transaction statistics on this? Is there a large gap between
> these?
>
>
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase & Firebird
> Firebird Workbench - the developer tool for Firebird
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>