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: [email protected] [mailto:[email protected]] On Behalf Of Chris Austin Sent: Monday, April 21, 2014 12:39 PM 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
