[U2] INDEX taking forever to rebuild after server upgrade.
Chris Austin <[email protected]> Mon, 21 Apr 2014 11:39:05 -0500
| Newsgroups | gmane.comp.db.u2.general |
|---|---|
| Message-ID | <[email protected]> |
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