Yeah, 18 indices is gonna hurt; you have to open 19 files every time you open
that file. If MFILES isn't pretty high (and any corresponding parameter in the
OS, like nofiles in AIX), you'll be expending a lot of resources just opening
& closing files. Then there's the performance hit of doing about 20 physical
writes every time you update a record.> Subject: RE: [U2] UniVerse Index
Files> Date: Thu, 28 Aug 2008 08:56:38 -0400> From: [EMAIL PROTECTED]> To:
[email protected]> > Thanks for all the info. We are using bscan to
search and sort a very> large file and already have 18 indices (yikes) on one
file. It might be> best to rewrite the app rather than adding more indices.> >
-----Original Message-----> From: [EMAIL PROTECTED]>
[mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod> Sent:
Tuesday, August 26, 2008 7:00 PM> To: [email protected]> Subject:
RE: [U2] UniVerse Index Files> > The limit is 1000. This results from the
actual index files following> the naming convention INDEX.nnn starting from
000.> > Every index degrades update performance, so you should still be>
selective.> --------------------------------------------------------> > Access
Manager: This email is intended only for the person or entity to which it is
addressed and may contain information that is privileged, confidential or
otherwise protected from disclosure. Dissemination, distribution or copying of
this e-mail or the information herein by anyone other than the intended
recipient, or an employee or agent responsible for delivering the message to
the intended recipient, is prohibited. If you have received this e-mail in
error, please immediately notify us by calling the Help Desk at (212) 999-9911
or email us at [EMAIL PROTECTED]> -------> u2-users mailing list>
[email protected]> To unsubscribe please visit
http://listserver.u2ug.org/
_________________________________________________________________
Talk to your Yahoo! Friends via Windows Live Messenger. Find out how.
http://www.windowslive.com/explore/messenger?ocid=TXT_TAGLM_WL_messenger_yaho
o_082008
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
