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!
|
|
7.2 SLX client - Slow to load
Posted: 10 Apr 08 10:41 AM
|
I'm upgrading SLX 6.2.6 to 7.2.2.
After installing it was working fine, but after 2-3 weeks SLX client becomes deadly slow to load. I checked each step of the client loading and found that "Loading Groups" process takes long time. Why this is happening?
Thanks |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 10 Apr 08 12:26 PM
|
| I reinstalled client application, but the problem still remains. I compare SLX 6.2. In 6.2 it takes few second to load Groups on initialization. |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 11 Apr 08 11:08 AM
|
I ran into this issue as well. However, the cause was not consitsent. Verify that during the upgrade process that a User's defaults are populated. Specifically, the defualt group for each module. Have the user reset these; this cleared the issue 80% of the time.
c |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 11 Apr 08 4:36 PM
|
I think I'm having the same problem.
Does the reset have to be done through the App or is there a way to reset that stuff using SQL?
Thanks! |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 11 Apr 08 4:40 PM
|
Great Question! I don't know of one off hand as the 'User Defs' structure changed from 5.2 (which is where both you and I upgraded from. Ug!) to later versions. Let's throw it out there...
Has anyone done this?
Carla |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 12 Apr 08 10:57 AM
|
What does this have to do with Userdefs?
Or am I thinking of the field in SecTableDefs......
There are a number of groups and grids in 7.22 that have performance issues......SLX working on it.....there was a post the other day about setting '' OpportunityID's in ATTACHMENT to NULL....sped things up Exponentially.
Groups needs tweaking when you convert from 5.xxx. Make sure Indexes on are on the key fields AND properly formed (that's like step 29 in the conversion process!), VSSC turned on for groups, etc. |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 14 Apr 08 9:51 AM
|
| It can be done in the app. The user can do it on Tools-->Options-->LookUps & Groups or you can do it in the Administrator under the Client Settings tab of the user. |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 17 Apr 08 2:28 PM
|
RJ,
I wasn't able to locate the Index reference that you made as step 29 in the Upgrade documentation is that step 24 or do you have anymore information on SLX indexes that I could take a look at? My performance is pretty slow and I'm trying to optimize with some well placed Indexes and my DBA wants more specific details.
I'm also looking at the use of VSSC on my groups and I'm finding that it isn't set for most of them, so hopefully that will help, but I have a question: If there's a small amount of data in the data grid then I want VSSC off and if there's a large amount then I want them on, correct?
Here is the SQL I'm using to fix the Attachment tab (we don't use Opportunities) does this seem like it will fix the problem that you described?
Update Attachment
Set opportunityid = null
Where opportunityid is not null
Any other 5.2>7.0.1 optimization tips would be appreciated!
Thank you guys!
 |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 18 Apr 08 10:38 AM
|
If you don't use opportunties, I don't beleive that statement would make a difference.
If your issue seems to be linked to when the user last had an attachement tab visible, the statement to run would be
Update Attachment
Set --foreignkeyid-- = null
Where --foreignkeyid-- = ''
Repeat with accountid, contactid and ticketid
|
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 21 Apr 08 2:00 PM
|
Carla,
So would you want to select the User's default groups or set it to ""?
Also did you create new groups in the v7.0 after the upgrade? We're considering that at the moment, but there are a lot of groups to recreate.
Thank you! |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 22 Apr 08 9:11 AM
|
If I were you, and I am to a degree coming from 4.0, I would take a blank 7.2 database, capture the indexes, blow away your production indexes, and recreate them from the blank exactly.
Throw all of the index changes in a SQL statement and execute it on the remotes directly due to possible sync issues (mainly with regards to the sync table indexes). While you're at it I would make sure the primary keys match up too because coming from interbase meant we didn't really need the primary keys defined when we moved to MSSQL. The keys defined in 5.2 also don't match the 6.x+ naming conventions used either.
There was only one index that caused problems for us and it was HISTORY2 (or something like that) on the history table. It's a clustered index that when not matched with the 6.x+ index causes some minor naggles for remotes. It's pretty easy to fix though.
Aside from that, groups are different when you upgrade. Look at an upgraded group through a tool like John Hedges' Electrician versus a newly created group and there the underlying data structures are different. I can't remember when I did this but I believe I was looking at a pre 6.1 group versus a 6.1 group and there are some very slight but noticable differences. It's easy to recreate a group though, just click Copy and it'll create a "new version" with all of the old data. I believe the differences were due to virtual server side cursors mainly but I don't think you have to recreate groups every major version upgrade. I haven't since our jump to 6.1 and all of them are doing fine to my knowledge. |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 22 Apr 08 9:13 AM
|
| Sorry for not answering the first part directly. Set everyone's default groups to "Latest..." it's what SalesLogix defaults to when you create a new user. Just make the changes for all the users in administrator then those changes should sync out to everyone. Back in 5.2 land you had to do this by logging in as every user but you could even login as remotes on the host, make the change, and it would sync out as well. The only real difference is 6.x+ exposed that functionality to the administrator application. |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 25 Apr 08 1:20 PM
|
Hey, thanks for the reply...I was on hold becasue of some other priority tasks,
The "Slow" issue starts when SLX SP2 is installed. SLX 7.2 is working fastly for me after I upgraded to 7.2, but becomes deadly slow after SP2 installed. I confirmed this scenario 2 times.
Do you have any suggestions?
I'm upgrading Desktop version only, so I ignored steps for web upgrade, Is it make any problem?
|
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 02 May 08 8:32 AM
|
At last, I found the reason for the performance issue. I tried with deleting all the user created groups in TEST environment. I've hundreds of user created groups. Then it working fine.
So something is wrong with some of these groups and I'm trying to findout that.
Thanks to all for the valuable replys.
Aji |
|
|
| |
|
Re: 7.2 SLX client - Slow to load
Posted: 04 May 08 11:12 AM
|
Originally posted by Mike Spragg
This was my reply to you my you first posted it on IT Toolbox. So, I don't think you found it at all  |
|
Mike, I saw his posting (on ItToolbox) and your reply as well.. I agree on your conclusion 1000%
--
RJLedger - rjlSystems |
|
|
|
.
Posted: 05 May 08 8:14 AM
|
| . |
|
|
|
Re: 7.2 SLX client - Slow to load
Posted: 05 May 08 8:18 AM
|
Originally posted by Mike Spragg
This was my reply to you my you first posted it on IT Toolbox. So, I don't think you found it at all |
|
Yes Mike, you are correct But at that time I couldnt findout the issue thru profiler. 
There is a big difference noticed when compared to 7.2-SP2 and 7.2-SP1 or older. In SP2 lot of group SQLs are executing while loading SLX, but in SP1 or earlier version, these group SQLs are not executing at the beginning. That's why 7.2 and 7.2 with SP1 is working fine. Why SLX executing all these SQLs the beginning for SP2 only?
I cant delete all groups I've. please give your suggestions to improve the performace.
|
|
|
|