By "Sizable", are you talking 10k, 50k, 100k, larger? The Seperation would
become a huge factor, then. Mark Baldridge wrote some great stuff about Sep in
"The Hitchhiker's Guide to the UniVerse" series a few years back. You wouldn't
happen to be on AIX, would you? If so, as root, you could do a "truss -pdf
pid" to see every system call made by the process, along with a time stamp
telling you the time delta between each system call.
> Date: Mon, 30 Apr 2012 21:01:07 -0400
> From: dlaan...@hubbardsupply.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] READU vs READ
>
> 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