Hi

I am not able to tell wether this will work as expected at all.
Maybe someone else is.

Be you need to see, that database servers lock information as they work. So
slowing down one process and speed up another might leed to the situations
where one process is very fastly waiting for another process working slowly.
If you do not have any really time-critical operations, let firebird decide,
when to do what.

Any if you HAVE such problems, maybe you store incoming information on
another system and transfer them during lower load times.

Regards,
Steffen



-----Original Message-----
From: Fabrice Aeschbacher [mailto:fabrice.aeschbacher@...]
Sent: Wednesday, May 26, 2004 11:14 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] give priority to connections

Hi,

[Firebird 1.5 CS / linux]

I have 2 connections to the DB:
- conn1 used to insert datas
- conn2 used to select datas

I want the instance of the fb_inet_server process associated with the
connection doing the SELECTs (conn2) to be started with a lower priority
(say: nice 10).

How can I achieve this, without having to renice manually the process?

Is it possible to have to use 2 communication ports (say, 3050 and 3051),
and tell inetd to start fb_inet_sever with nice 10 when the connection is
opened on the port 3051?

Is there any other solution?


Best regards,
Fabrice Aeschbacher




------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/67folB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links