Sounds like a lot of extra work to get a mediocre report engine to run fast.
You could also use an indexed date attribute to speed up MITS (if you're using a transaction based file)... At the end its still crappy MITS. :-D -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marvin R. Fisher Sent: Tuesday, May 13, 2008 4:46 PM To: [email protected] Subject: RE: [U2] Using ETL to extract data from UD to SQL Using Dynamic Change Update in MITS removes the need for the select and merge method. You just have to know which applications write to the source file and modify them to write MITS.TODOS_app records for new source records, MITS.REDOS_app records for changed source records and MITS.UNDOS_app records for deleted source records. Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Friday, May 09, 2008 7:26 AM To: [email protected] Subject: RE: [U2] Using ETL to extract data from UD to SQL Well, MITS does a SELECT against their copy, then against the source copy and then merge the list. So - the larger it gets - well.... (Not to mention I think MITS is a hunk of glorified crap) I've had no issues using triggers. (My box is huge thou....) > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
