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