[U2] INDEX taking forever to rebuild after server upgrade.

2014-04-21 Thread Chris Austin
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

Re: [U2] INDEX taking forever to rebuild after server upgrade.

2014-04-21 Thread Ladd, Ryan
Chris, Does your index return a bunch of empty string values? If so, your CREATE.INDEX command might have needed a NO.NULLS keyword to prevent index records from being created. Ryan -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] INDEX taking forever to rebuild after server upgrade.

2014-04-21 Thread neil
Chris, did you open a support case with Rocket on this? On Apr 21, 2014, at 9:39 AM, Chris Austin cjausti...@hotmail.com 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

Re: [U2] INDEX taking forever to rebuild after server upgrade.

2014-04-21 Thread Allen Egerton
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

Re: [U2] INDEX taking forever to rebuild after server upgrade.

2014-04-21 Thread Chris Austin
Ryan, That's a good point, we do have a lot of strings with NULL so maybe setting NULLS to NO would help. Chris From: ryan.l...@meritain.com To: u2-users@listserver.u2ug.org Date: Mon, 21 Apr 2014 12:47:38 -0400 Subject: Re: [U2] INDEX taking forever to rebuild after server upgrade.

Re: [U2] INDEX taking forever to rebuild after server upgrade.

2014-04-21 Thread Chris Austin
No, we have not since I wasn't sure if it was something on our end or with the new version of UniVerse. Has this come up with anyone else by chance that you know of? Chris From: neilri...@gmail.com Date: Mon, 21 Apr 2014 09:48:07 -0700 To: u2-users@listserver.u2ug.org Subject: Re: [U2]

Re: [U2] INDEX taking forever to rebuild after server upgrade.

2014-04-21 Thread neil
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

Re: [U2] Dataflo programmer- ERP project in Irvine / CA / 92618.

2014-04-21 Thread Allen Elwood RR
hello khushboo sorry to say i'm disabled/retired with severe crps/rsd in my right hand leaving me unable to type fast enough or long enough to be effective in the work place, since I have to do all typing with just my left hand and take tramadol for pain management i have cc'd your message

[U2] dynamic connect

2014-04-21 Thread Dale Kelley
I have a customer who just upgraded all workstations to windows7. I installed dynamic connect to replace their uvterm. Under SETUP I made them VT100 set up the scripts and folders, (all default directories), and saved session1.dcs. I had to SET the numeric keypad and have saved the numeric

Re: [U2] dynamic connect

2014-04-21 Thread Larry Hiscock
Sounds like a UAC issue. A lot of applications try to store their settings/config/.ini files in their program directory (i.e. c:\program files\application\, where application is the directory the application uses). In Windows 7, UAC wants to redirect those to the users %APPDATA% directory (e.g.