For what's it worth I did some more tests on a stand-alone machine with a normal IDE disk, no disk cache and I restarted it between tests to be sure nothing was lurking in memory.
Update of 1,000 single byte records to a dynamic file took 0.14 secs with no trigger and 1.35 with a blank trigger. Same update with 10,000 records took 0.47 and 13 seconds. Something not right somewhere...... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Lewington Sent: 06 September 2004 17:09 To: [EMAIL PROTECTED] Subject: Re: [U2] Anyone have experience "mirroring" a HDD over a WAN I think the ratio may be a bit of a red herring. John is taking an extra 40 seconds for 10,000 updates with triggers - about 4ms per call - on a time of 324 w/o triggers - about 32ms per write. You're taking an extra 600 or so seconds for 500,000 updates with triggers - about 1ms per call - on a time of 60 secs w/o - about 0.1ms per write. So your test was 300 times quicker writing data, but only 4 times quicker running the trigger. You could change the ratio to nearer to 1 by lowering the write speed as well as by upping the trigger speed. What you may want to check is how long a real-world write takes - your example is quick here because the file is cached, but it may be the case that you have more un-cached writes from your application, and so the trigger overhead is less significant. However - I do think that 1ms per trigger call seems excessive - we're below 0.1ms on our UD / NT system. Simon "Dennis Bartlett" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Ok, so something has to be different... > we still think you're smoking something... > > my ratio is somewhere around 1 to 10 > your ratio is 1 to 1.15 > > with your ratio I'd happily embrace triggers. > > Please post (possibly privately?) your uvconfig file, what the specs of > your machine are (ie no of cpus, memory, whether your files are stored > in RAM...) > > basically, if IBM could get their act together on this, and make our IBM > p615 work like your Sun whatever, we'd be happy as pigs in top dressing! ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
