Well, that'll affect performance somewhat. If you're splitting on a high
percentage of writes, that's a lot of expensive overhead. You also (unless
someone changed it in the past couple of years) have to lock the header of the
file when you do a split. But at least you're not following overflow chains out
into West Jibip. The disks/file systems you're writing to aren't more than 85%
full? Attaching new disk pages to the dynamic file as it grows can be a
bottleneck in that scenario...
> Date: Mon, 30 Apr 2012 21:35:47 -0400
> From: [email protected]
> To: [email protected]
> Subject: Re: [U2] READU vs READ
>
> It's a dynamic file. FILE-STAT shows no overflow.
>
> 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: [email protected]
> [mailto:[email protected]] On Behalf Of Buss, Troy
> (Contractor, Logitek Systems)
> Sent: Monday, April 30, 2012 9:12 PM
> To: U2 Users List
> Subject: Re: [U2] READU vs READ
>
> Inefficient file sizing and disk I/O are your possible issues with
> slowness. You might be able to address the first at your desk, the
> latter may require a purchase order. How old is your hardware?
>
> We recently upgraded to a virtual server and just using more current
> technology hard drives we doubled all of our disk I/O from what we had 5
> or 6 years ago. CPU speed increased as well, but that was not as
> suprising.
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Dave Laansma
> Sent: Monday, April 30, 2012 6:01 PM
> To: U2 Users List
> 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.
>
>
> ________________________________________________________________________
> _____
> 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
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> 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
