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

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to