thank you helen,
i can say what i saw in the systemmonitor, if trying different Affinity
settings:
(p.s. i installed now a networkmonitor and this shows me, i have 70
connections or so
over gds_db port)
(the server is a PII with 2 400 MHz Processors, Asus Motherboard and
SCSI-drives)
(the db is 1 Gigabyte)

cpu_affinity = 1 -> the first cpu is going to 100%
cpu_affinity = 2 -> then second cpu is going to 100%
cpu_affinity = 0 -> both are running nearly synchroneus and not going to
100%, BUT
the IBServer-Process reaches often 100% ?!?!?!
-----------------------------------------------
now i will try a new ibconfig, this one:

V4_LOCK_MEM_SIZE 196608 !!!
#V4_LOCK_SEM_COUNT 32
#V4_LOCK_SIGNAL 16
#V4_EVENT_MEM_SIZE 32768
DATABASE_CACHE_PAGES 4096 !!!!
SERVER_PRIORITY_CLASS 2
#SERVER_CLIENT_MAPPING 4096
#SERVER_WORKING_SIZE_MIN 0
#SERVER_WORKING_SIZE_MAX 0
#V4_LOCK_GRANT_ORDER 1
ANY_LOCK_MEM_SIZE 196608 !!!
#ANY_LOCK_SEM_COUNT 32
#ANY_LOCK_SIGNAL 16
#ANY_EVENT_MEM_SIZE 32768
#LOCK_HASH_SLOTS 101
CPU_AFFINITY 3 !!!!
----------------------------------------------
pleas tell me, if you see here is something wrong ...
many thanks
-gerhard

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, June 12, 2002 12:18 PM
Subject: Re: [ib-support] Re: Firebird Client


> At 11:58 AM 12-06-02 +0200, you wrote:
> >...
> >#LOCK_HASH_SLOTS 101
> >CPU_AFFINITY 0
> >...
>
> This is wrong. Here are the options:
>
> CPU_AFFINITY 1
> only runs on the first CPU (CPU 0).
> CPU_AFFINITY 2
> only runs on the second CPU (CPU 1).
> CPU_AFFINITY 3
> runs on both first and second CPU.
>
> So you need to set this to be either 1 or 2, because a setting of zero
> doesn't set affinity at all.
>
> heLen
>
>
> All for Open and Open for All
> Firebird Open SQL Database · http://firebirdsql.org ·
> http://users.tpg.com.au/helebor/
> _______________________________________________________
>
>
>
> 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/
>
>
>