RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands
Alas! I have to return with my tail 'tween my legs! --- IBM P615 AIX 5.2 Universe 10.1.2 2 cpu --- Test Data : 500,000 invoice records, a trigger with a RETURN as the first statement Method: Copy from XXX to YYY (where YYY has the trigger added) Done after hours on a fairly idle box. nmon: reported a CPU usage of 85-98%, mainly 98.6 to 98.8 range. --- Adrian, you're right. My "without" copy took 60.2 seconds, the "with" copy (with just the RETURN) took 603.7 seconds!!! --- Sadly, it just isn't worth going the trigger route. Perhaps IBM should take note - this is DEFINITELY just a marketing ploy (Leroy? Kurt? Jackie?) John, regarding your results, did you remember to actually add the trigger? -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] My basic program selected the whole file (70,000 records) I'm running Universe 10.1 on Windows 2000. -Original Message- From: John Reid My with and without scores were 78 seconds and 80 seconds respectively. -Original Message- From: Adrian Matthews Creating a series of records took 17 seconds without the trigger and 291 with it. Quite an overhead I'd say. - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands
Strange. My trigger was the same; simple return with AFTER INSERT OR UPDATE OR DELETE. System load was very low as it was the development server I was uding. My basic program selected the whole file (70,000 records) then simply read each one and wrote each one so the trigger was called even though the record had not changed. I'm running Universe 10.1 on Windows 2000. Perhaps that's the difference? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Reid Sent: 01 September 2004 20:35 To: '[EMAIL PROTECTED]' Subject: RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands My with and without scores were 78 seconds and 80 seconds respectively. Yes, without took longer. It was 1000 updates, the same record set, and a simple RETURN after the parameters. The trigger was AFTER INSERT UPDATE DELETE. Maybe the INSERTS take longer or system load may have been radically different. j -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Tuesday, August 31, 2004 6:24 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Trigger not intensive, it's what you do with trigger! Was RE: [U2] Dot Commands I beg to differ. I created a trigger program that does nothing; just the subroutine header and a RETURN. Creating a series of records took 17 seconds without the trigger and 291 with it. Quite an overhead I'd say. Adding hardware won't sort the replication problem. Universe will not allow a published or subscribed file to have triggers on it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 31 August 2004 09:18 To: [EMAIL PROTECTED] Subject: [U2] Trigger not intensive, it's what you do with trigger! Was RE: [U2] Dot Commands A trigger need not necessarily be intensive - tho' admittedly the concept of an audit or any process requiring a write will mean the extra overhead of that write. The thing to watch out for is the temptation to read lots and write lots... Then imagine this blowing out exponentially as 3 zillion records are written, read, updated, and deleted. If, however, you intend to entirely cripple a site, you could always add triggers to update files that in turn have triggers that update others in a sort of "round-robin"... just imagine, what overhead that would involve! As for replication - just add another hardware controller to machine - every write will initiate two hardware writes --> no lag, overhead, everything instant. -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 August, 2004 9:02 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Dot Commands Bear in mind though that a trigger is a very intensive thing to add to a file. Just try timings on writes with and without them. Also you cannot replicate a file with triggers (major problem for use that I would LOVE IBM to fix.) - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- 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/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this messag
RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands
My with and without scores were 78 seconds and 80 seconds respectively. Yes, without took longer. It was 1000 updates, the same record set, and a simple RETURN after the parameters. The trigger was AFTER INSERT UPDATE DELETE. Maybe the INSERTS take longer or system load may have been radically different. j -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Tuesday, August 31, 2004 6:24 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Trigger not intensive, it's what you do with trigger! Was RE: [U2] Dot Commands I beg to differ. I created a trigger program that does nothing; just the subroutine header and a RETURN. Creating a series of records took 17 seconds without the trigger and 291 with it. Quite an overhead I'd say. Adding hardware won't sort the replication problem. Universe will not allow a published or subscribed file to have triggers on it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 31 August 2004 09:18 To: [EMAIL PROTECTED] Subject: [U2] Trigger not intensive, it's what you do with trigger! Was RE: [U2] Dot Commands A trigger need not necessarily be intensive - tho' admittedly the concept of an audit or any process requiring a write will mean the extra overhead of that write. The thing to watch out for is the temptation to read lots and write lots... Then imagine this blowing out exponentially as 3 zillion records are written, read, updated, and deleted. If, however, you intend to entirely cripple a site, you could always add triggers to update files that in turn have triggers that update others in a sort of "round-robin"... just imagine, what overhead that would involve! As for replication - just add another hardware controller to machine - every write will initiate two hardware writes --> no lag, overhead, everything instant. -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 August, 2004 9:02 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Dot Commands Bear in mind though that a trigger is a very intensive thing to add to a file. Just try timings on writes with and without them. Also you cannot replicate a file with triggers (major problem for use that I would LOVE IBM to fix.) - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- 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/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/