I checked the Rocket support system and did not see anything related to poor 
index build performance lately. Allen’s prognosis would be a good one to follow 
as indexing NULLS is not good (unless thats what you really need)

Neil Richards
Sales Engineer
Rocket Software

On Apr 21, 2014, at 9:48 AM, Allen Egerton <aeger...@pobox.com> wrote:

> 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

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

Reply via email to