That is WAY too long. Are your files sized correctly? READ vs READU should not be a resource pig like you are seeing. A little, sure, but not THAT much.
Something else is in the mix. John Israel Sent from my iPhone On Apr 30, 2012, at 9:01 PM, "Dave Laansma" <dlaan...@hubbardsupply.com> wrote: > Yes, using SELECT and READNEXT. These are sizable records. The logic is > very straight forward, just updating several multi-valued fields in each > record (month end). > > 500,000 have been updated and I'm 2:45:00 into the process. > > Sincerely, > David Laansma > IT Manager > Hubbard Supply Co. > Direct: 810-342-7143 > Office: 810-234-8681 > Fax: 810-234-6142 > www.hubbardsupply.com > "Delivering Products, Services and Innovative Solutions" > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy > (Contractor, Logitek Systems) > Sent: Monday, April 30, 2012 8:48 PM > To: U2 Users List > Subject: Re: [U2] READU vs READ > > Depends on how much <twisted logic> you have... Seriously, I would > guess that your bottleneck is disk access. > > Are you using basic SELECT and READNEXT ? Is your list in sorted order > (SSELECT) or not (SELECT). > > Processing the updates in group order will minimize the I/O. I don't > think the READU overhead on today's machines are anything that would > slow it down. I just tested 100,000 records with and without locking > and I get six seconds both ways. Because it was cached data, my test > eliminates disk i/o and measures the lock overhead which seems to be > negligible on universe 11.1.1. > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma > Sent: Monday, April 30, 2012 5:33 PM > To: U2-Users@listserver.u2ug.org > Subject: [U2] READU vs READ > > If I don't HAVE TO lock a record before modifying it writing it back, > will a program run significantly faster if I just WRITE it back without > locking it first? I'm updating about 700,000 records and it's just > taking TOO long. > > > > I DO understand the risks of other users changing the record's content > during so let's not go down that road. I'm interested in the SPEED > dialog. > > > > Thank you folks! > > > > Sincerely, > > David Laansma > > IT Manager > > Hubbard Supply Co. > > Direct: 810-342-7143 > > Office: 810-234-8681 > > Fax: 810-234-6142 > > www.hubbardsupply.com <http://www.hubbardsupply.com> > > "Delivering Products, Services and Innovative Solutions" > > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ________________________________________________________________________ > _____ > Scanned by IBM Email Security Management Services powered by > MessageLabs. For more information please visit http://www.ers.ibm.com > > This email is intended only for the use of the party to which it is > addressed and may contain information that is privileged, confidential, > or protected by law. If you are not the intended recipient you are > hereby notified that any dissemination, copying or distribution of the > email or its contents is strictly prohibited. If you have received this > message in error, please notify us immediately, by replying to the > message and deleting it from your computer. > > WARNING: Internet communications are not assured to be secure or clear > of inaccuracies as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. Therefore, we > do not accept responsibility for any errors or omissions that are > present in this email, or any attachment, that have arisen as a result > of e-mail transmission. > ________________________________________________________________________ > _____ > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
