I checked the Rocket support system and did not see anything related to poor index build performance lately. Allen’s prognosis would be a good one to follow as indexing NULLS is not good (unless thats what you really need)
Neil Richards Sales Engineer Rocket Software On Apr 21, 2014, at 9:48 AM, Allen Egerton <aeger...@pobox.com> wrote: > Possibly you're indexing nulls, which will give you a very large branch of > the tree. > > EXECUTE "DELETE.INDEX ": FILENAME: " ": FIELD.NAME > EXECUTE "CREATE.INDEX ": FILENAME: " NO.NULLS" > EXECUTE "BUILD.INDEX ": FILENAME: " ": FIELDNAME > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin > Sent: Monday, April 21, 2014 12:39 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] INDEX taking forever to rebuild after server upgrade. > > Hello, > > We recently upgraded to a new Windows 2012 R2 server with the latest version > of UniVerse (11.2.x). Everything seems to be working great except we noticed > that 1 index on 1 record is taking a TON of time to do a rebuild. > > The basic syntax we're using is > > > EXECUTE 'CREATE.INDEX ':FILENAME:' ':FIELDNAME EXECUTE 'BUILD.INDEX > ':FILENAME:' ':FIELDNAME > > The output looks like > > > Clearing Index File INDEX.007 > > Starting DATA processing for index 'OTHER_REF'! > **************************** 2251000 processed. > *********** > > However, this used to finish in a couple minutes and now runs for HOURS > without finishing. > > Any ideas what would cause this or how to remedy the situation? Maybe the > index is corrupt? > > Thanks, > > Chris > > > _______________________________________________ > 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
