Ryan, That's a good point, we do have a lot of strings with NULL so maybe setting NULLS to NO would help.
Chris > From: [email protected] > To: [email protected] > Date: Mon, 21 Apr 2014 12:47:38 -0400 > Subject: Re: [U2] INDEX taking forever to rebuild after server upgrade. > > Chris, > Does your index return a bunch of empty string values? If so, your > CREATE.INDEX command might have needed a "NO.NULLS" keyword to prevent "" > index records from being created. > > Ryan > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Chris Austin > Sent: Monday, April 21, 2014 11:39 AM > To: [email protected] > 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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > Note: The information contained in this message may be privileged and > confidential and protected from disclosure. If the reader of this message is > not the intended recipient, or an employee or agent responsible for > delivering this message to the intended recipient, you are hereby notified > that any dissemination, distribution or copying of this communication is > strictly prohibited. If you have received this communication in error, please > notify us immediately by replying to the message and deleting it from your > computer. > _______________________________________________ > 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
