Re: [U2] INDEX taking forever to rebuild after server upgrade.
neil <[email protected]> Mon, 21 Apr 2014 09:48:07 -0700
| Newsgroups | gmane.comp.db.u2.general |
|---|---|
| Message-ID | <[email protected]> |
Chris, did you open a support case with Rocket on this? On Apr 21, 2014, at 9:39 AM, Chris Austin <[email protected]> wrote: > 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users