IDS Forum

RE: - HDR performance to remote site with IDS 10 [

Posted By: Penza Kenneth at MITTS
Date: Thursday, 21 June 2007, at 8:01 a.m.

Mike,

It depends on the amount of rows you are commiting every time. The

fewer the commits the better the performance. I suggest that you use

dbload and you commit every of x rows. Start with a value of say 10000

and increase it if you have many logfiles go for bigger values but try

to avoid long transactions.

Regards

Kenneth

_________________________________________________________________

From: ids-bounces@iiug.org on behalf of MIKE SLAUGHTER

Sent: Thu 6/21/2007 11:27 AM

To: ids@iiug.org

Subject: [SPAM] - HDR performance to remote site with IDS 10 [9398] -

Email found in subject

Hello,

I have configured HDR several times from online 7 through IDS 10 but

always

over a LAN with both hosts at the same location.

We have tried our first IDS HDR pair over a remote link with both

servers

connected over a 2Mb/s link with a latency of around 10ms. Replication

is set

asynchronously. Data is being loaded into few tables only from an old

SE db

that the new instance replaces, this is a simple SQL script loading a

small

number of .unl files. This data size is around 13Mb.

With the primary in standalone mode the load is very fast, when HRD is

active

loading the same tables is very slow. Varying DRINREVAL also varies

the load

time as follows.

Load times;

standalone 00:00:13

DRINTERVAL = 30 00:05:12

DRINTERVAL = 300 00:04:48

So my question to you all is does this seem normal?

Chunks

size free bpages flags pathname

1048500 1045658 PO-B /dev/informix/rootdbs

1048576 23 PO-B /dev/informix/physicallogdbs

2621440 1621387 PO-B /dev/informix/logicallogsdbs

262144 241160 PO-B /dev/informix/nmcdbs

Regards

Mike

**********************************************************************

*********

Forum Note: Use "Reply" to post a response in the discussion forum.

IDS Forum is maintained by Administrator with WebBBS 5.12.