[Info-Ingres] Ingres Net and performance

Hi all:
I have Ingres 2006 r2 Ingres Vision applications running on a RHEL 4 64
bits running against Ingres 2.6 sp5 on Tru64 machine (using Ingres Net +
installation password).
Before this scenario, Ingres Vision applications were running on the
same tru64 DBMS Local hosts. On this old scenario my batch processes
were better peformance than with the new one (client/server).
I know that Ingres Net is a player here for performance degradation.
What I need to know if is there any Ingres net configuration parameter
or Linux/Tru64 OS parameters that I need to modify in order to increase
my batch processes performance

Any help will be appreciate

Oscar

PD: I have a gigabit connection between servers

--
Lic. Oscar Carlés Barriocanal
Director de Servicios al Cliente
Íntegra S.R.L.
Telefax: (595 21) 424473 RA
Asunción - Paraguay

"Oscar Carlés" wrote in message
news:mailman.300.1214348342.2607.info-ingres-at-kettleriverconsulting.com...
> Hi all:
> I have Ingres 2006 r2 Ingres Vision applications running on a RHEL 4 64
> bits running against Ingres 2.6 sp5 on Tru64 machine (using Ingres Net +
> installation password).
> Before this scenario, Ingres Vision applications were running on the same
> tru64 DBMS Local hosts. On this old scenario my batch processes were
> better peformance than with the new one (client/server).
> I know that Ingres Net is a player here for performance degradation.

What's the BIO count for one of these jobs? I don't want to leap to any
conclusions, but cursors are evil.

> What I need to know if is there any Ingres net configuration parameter or
> Linux/Tru64 OS parameters that I need to modify in order to increase my
> batch processes performance

Not really, no. If you have multiple concurrent batch jobs you might get
benefit from having multiple Ingres Net servers at each end. I wouldn't be
too optimistic though.

> PD: I have a gigabit connection between servers

Is it a dedicated connection? A crossover cable can produce miracles. I
had an application at one site that looked like it was going to run for 36
hours over what they were convinced was a high-speed connection. A back of
the envelope calculation showed they were getting a bare trickle of data. I
replaced the LAN with a crossover cable to run the job and it was done in
less than half an hour. It may not be a practical long-term solution but if
it works you will know where the problem is.

Roy
--
UK Ingres User Association Conference 2009 will be held on Tuesday June 9,
2009
Go to http://www.iua.org.uk/join to get on the mailing list.