[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