Margus, Wol's answer hit the nail on the head and will probably sort out the problem, but if it does not you might need to sit down and consider the variation in what you are indexing, as that is the main reason why an index will slow (if you have a million records and you are trying to index a field that can have only 20 different permutations, that is not a good idea).
You might need to condider looking at extending your application design, for example to see whether you can combine fields together into a single indexed idesciptor to provide better variance (this does not make sense for all data but a status code and a sub-status that are always selected together provides an example). Brian Leach -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 09 February 2004 09:46 To: U2 Users Discussion List Subject: RE: UV secondary index Two tricks to speed things up ... Firstly, would the NO.NULLS keyword speed things up? I'm guessing your fields can often be blank, and in this case you will have a single huge record knocking your index for six! Secondly, would the pause and resume indexing commands work? During the day, while the users are working, you pause index updates. At the end of the day (or whenever you need to run the reports) you resume indexing. Okay, it'll knacker the system while it sorts out the indices, but it'll be one short, concentrated hit. The you run your reports, disable indexing again, and let the users at it ... Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 February 2004 09:23 To: [EMAIL PROTECTED] Subject: UV secondary index Hello, I have distributed UV file with total size about 2.5Gb. I made secondary index CREATE. INDEX file field1 ... field6 BUILD.INDEX file field1 ... field6 After that, rows inserting takes very long time. (4000 rows. Server so busy, that other users can't do anything. If I removed index then inserting process is OK, but I need this index for reporting) Is it normal in UniVerse? How to avoid this problem? I use UniVerse 9.5.2 on AIX 5.2 Thanks, Margus Kandelin -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users **************************************************************************** ******* This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. **************************************************************************** ******* -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ________________________________________________________________________ This email was checked by MessageLabs SkyScan before entering Microgen. ________________________________________________________________________ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
