Maybe. There is the additional overhead of populating the DIM array on the MATREAD and the reverse on the MATWRITE. The more your program accesses the fields, esp. the more fields you have, then I agree, this can be MUCH faster.
However, it you have big records and all you are doing is updating field 1, you may be doing a lot of overhead without getting the bang for your buck. Write a simple program that simulates your effort with READS/WRITES and then again with MATREADS/MATWRITES. Depending on what you are actually doing may or may not make a huge difference. If your performance is a real issue, this could be well worth the effort. John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Nick Gettino Sent: Tuesday, May 01, 2012 3:45 PM To: '[email protected]' Subject: Re: [U2] READU vs READ Additional the larger the record the better the MATREADU works over the READU. Nicholas M Gettino, Director of Professional Services & Support, EnRoute Emergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, Suite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX (678) 393-5389 [email protected] or [email protected] From: Nick Gettino Sent: Tuesday, May 01, 2012 3:44 PM To: [email protected] Subject: [U2] READU vs READ Updating 700,000 records. If you want speed on the reads and writes the best way to accomplish it is to MATREADU the record equate the attributes you are going to update or all of them in case you ever want to add and then MATWRITE. It takes more coding, but it is well worth it. It takes a little longer to start the program ( a few seconds) but the results will amaze you compared to a normal READU. Nicholas M Gettino, Director of Professional Services & Support, EnRoute Emergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, Suite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX (678) 393-5389 [email protected]<mailto:[email protected]> or [email protected]<mailto:[email protected]> _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
