The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
SLX 6.2.6 to 7.2.2 upgrade -- performance issues
Posted: 27 Jun 08 1:26 PM
|
| LAN client extremely slow to open up...Building groups for over 1 minute...Yes the client's database is large (over 5GB); Rumor has it that indexes to custom tables may need to be rebuilt after the upgrade? Any input is appreciated...Cheers |
|
|
|
Re: SLX 6.2.6 to 7.2.2 upgrade -- performance issues
Posted: 28 Jun 08 1:01 AM
|
The handling of Groups is different under V7...
-V7 tries to default to Client Side Cursors. V7 used Server Side Cursors. This means the large groups are slower to load.
-In V7 the ADMIN user sees all groups. The first time I logon as ADMIN I set the ADMIN's group so ADMIN only sees groups owned by ADMIN.
-On large DBs you may need to tweak groups to use VSSC (Virtual Service Side Cursors)
|
|
|
|
Re: SLX 6.2.6 to 7.2.2 upgrade -- performance issues
Posted: 29 Jan 09 8:23 AM
|
I had performance issue when trying to view attachment tab. As it turned out SLX 7.2 does not like attachment table to have black fields. After changing all empty entries to NULL attachment groups loads in fraction of a seconds vs 15 minutes. You may want to see if there are empty fields in the table you are accessing. Our DB is >3GB withabout 100k file attachment.
Here's what i ran:
update attachment set ticketid = null where ticketid = ''
update attachment set opportunityid = null where opportunityid = ''
update attachment set contactid = null where contactid = ''
update attachment set contractid = null where contractid=''
Good luck
|
|
|
|
Re: SLX 6.2.6 to 7.2.2 upgrade -- performance issues
Posted: 29 Jan 09 10:43 AM
|
Frank,
What do you mean when by "set the ADMIN's group so ADMIN only sees groups owned by ADMIN"? I've just upgraded from v6.2.6 to v7.5 and my Admin view now shows a group for every user to which the group is shared. (e.g. VIP Contacts shared to four users now shows in my list four times). I've got about 80 groups created by the admin all shared differently...so instead of seeing 80 I see hundreds. This, of course, makes my list view unusable. |
|
|
|
Re: SLX 6.2.6 to 7.2.2 upgrade -- performance issues
Posted: 29 Jan 09 11:21 AM
|
Jason,
When you run the SalesLogix client as ADMIN there is a new option added at the bottom of the "Group Manager" dialog which will allow you to control what groups are displayed. Try setting it to Show groups owned by Administrator. |
|
|
| |
|