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

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.