UD does indeed have NO.NULLS -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, September 10, 2010 10:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Slow READ/WRITE with indexes {Unclassified}
On 09/09/10 21:29, HENDERSON MIKE, MR wrote: > Ryan, > > You said you had indexes like "'ORDER.DATE', 'COUNTRY', 'MEMBER ID'". If > those are really the full index data items, you could have thousands, > tens of thousands, or even hundreds of thousands, of records with the > identical index data item value in the SOH file. If that's the case, > updates (inserts) may well be s-l-o-w as the system churns through many, > many, many linked buffers of identical valued keys looking for an insert > point. That was my thinking too. The other, related point. Does UD have NO.NULLS? And are you using it? If you haven't used it that's the most common performance-killer with indices out there ... Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ########################################################################################### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ########################################################################################### _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users