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!
|
|
Slow Loading Groups
Posted: 14 Jan 09 8:38 AM
|
We are having an issue when logging into the client or doing a CTRL-F5 refresh. When the splash screen gets to the point of saying "Refereshing Environment - Loading Groups" it will take up to 3 minutes sometimes to get passed this. Has anyone run into this issue or have an idea what might be happening?
I was looking for the code that does the full refresh but I couldn't find it. Does anyone know where this code is?
One suggestion SLX support made was to bundle all the groups in a development environment and then start deleting them in groups of 10 or 20 at a time using DELETE TOP (xx) then test after each delete. The idea behind this was to narrow it down to a possible corrupt plugin. I've tried this and haven't come up with any definitive answer. Maybe its a combination of plugins? At this point I'm stumped.
Any ideas what to do next would be appreciated.
Thanks,
John G. |
|
|
| |
|
Re: Slow Loading Groups
Posted: 14 Jan 09 2:21 PM
|
It could be an index issue.
The below script will rebuild all the indexes on your DB.
Exec sp_msforeachtable @command1="print '?' dbcc dbreindex('?', '',0,sorted_data_reorg)" |
|
|
|
Re: Slow Loading Groups
Posted: 14 Jan 09 2:25 PM
|
We just upgraded to 7.2.2.
I believe there are missing indices. I had taken the definitions from the eval database but something must still be missing.
John G. |
|
|
|
Re: Slow Loading Groups
Posted: 15 Jan 09 3:04 AM
|
Hi John
How many groups are there. Also, do you have [lots] of groups called NewQuery - as you can certainly delete those (there was an issue with that).
Mike
|
|
|
|
Re: Slow Loading Groups
Posted: 15 Jan 09 3:08 AM
|
Missing indices doesn't sound good. any reason why?
I would rebuild the indexes anyway see if that has an effect.
Also try changing the default start up group to see if its a problem with a particular group.
Finally I would use the SLXProfiler.exe to see what sql is taking so long.
|
|
|
|
Re: Slow Loading Groups
Posted: 15 Jan 09 6:21 AM
|
This is not happening for all users, just some. It happens no matter which box I log into. So it seems to be specific to a released group. Which one is the problem.
I ran the reindex for all tables and indices. Still no improvement.
There are a total of 1,543 groups.
Account = 495
Contact = 831
Opportunity = 217
Mike: I think you mean "NewGroup" not "New Query". I have been deleting the 'NewGroup' groups. I just deleted 150 of them. Even without them it takes forever at 'Loading Groups'.
After doing all the above suggestiong I logged in as various users and they all load groups in under 10 seconds. When I log in as myself or admin it takes close to 2 minutes. Is there a query that can tell which groups are released to a specific user?
I think the problem being an index is less likely but I'm not ruling it out just yet. I'm going to post what indices there are for the plugin table. Are there any other tables that might be involved?
Thanks!
John G.
|
|
|
|
Re: Slow Loading Groups
Posted: 15 Jan 09 6:56 AM
|
Here is the list of indexes for the plugin table
PLUGIN_AUTHOR
PLUGIN_BASEDON
PLUGIN_COMPANY
PLUGIN_COMPANYVERSION
PLUGIN_FAMILY
PLUGIN_NAME
PLUGIN_PLUGINID_PK
PLUGIN_TYPE
PLUGIN_USERID
John G. |
|
|
|
Re: Slow Loading Groups
Posted: 15 Jan 09 7:28 AM
|
Correct, yes - NewGroup!
I would break out the SLXProfiler and monitor what it's doing during the loading process - looking for delays etc. Also, send me an email and I can send you a util that shows what groups are owned/shared with what users. |
|
|
|
Re: Slow Loading Groups
Posted: 15 Jan 09 9:03 AM
|
Hi John,
7.22 HF11 will probably fix your issue, if you haven't applied it yet. With 7.2, there is a pre-parsing of all groups going on when you're launching the client. HF11 fixes an issue where you will sometimes get an error if it hits a bad query, but it doesn't tell you which group is the bad one. (I had reported this issue) Doesn't sound related, I know, but in fixing that issue, they must have re-written exactly how the loading groups goes. Perhaps they quit pre-parsing them all. Because once you put that hotfix in, the groups load significantly faster. You might give that a try.
Becki Blackburn |
|
|
|
Re: Slow Loading Groups
Posted: 15 Jan 09 9:19 AM
|
Becki,
Wow! That worked! My client loads in no time.
A bad query is likely the culprit I'm sure. I never received any messages stating there was an issue. The splash screen just hung.
Problem solved.
Thanks!
John G. |
|
|
|
Re: Slow Loading Groups
Posted: 15 Jan 09 9:41 AM
|
Oh great news!
I think there is more to it then a bad query - they must have decided to not pre-parse the groups at all. If you think about it, a user with a log of groups (we're talking about all mainviews), it would take a long time to go through each group and make sure the sql can parse correctly. Even if they are all good, which may be the case with you, it just takes time to do all of this. I don't recall why exactly they were doing it that way, but it was probably to help with performance once logged in, to navigate between groups. But either way, whatever they did in that hotfix (which was originally going to be HF4 but that never came out), it completely changes the login experience. I have customers who would complain about 3-4 minute logins, and now can login in less than 20 seconds.
OH, and pre-HF11, forget about trying to login as Admin, if you accidentally changed your Manage Groups settings to "show all that are visible to Admin" - I did that, and after 30 minutes, went into the Useroptions table and manually changed it to "owned by".
Glad that worked for you. Have a great day!
Becki |
|
|
|
Re: Slow Loading Groups
Posted: 05 Feb 09 11:04 AM
|
I'm having a similar problem with groups and I also wanted to check the indexes on the database.
However, I get an error when I run the script:
An incorrect number of parameters was given to the DBCC statement.
Any thoughts? |
|
|
|
Re: Slow Loading Groups
Posted: 06 Feb 09 3:04 AM
|
Will depend on version:
' SQL 2000
Exec sp_msforeachtable @command1="print '?' dbcc dbreindex('?', '',0,sorted_data_reorg)"
' SQL 2005
Exec sp_msforeachtable @command1="print '?' dbcc dbreindex('?', '',0)" |
|
|
| |
|
Re: Slow Loading Groups
Posted: 06 Feb 09 7:35 AM
|
| I ended up have nearly 3000 groups. I'm going through them now. Using the script as suggested above already improved load time for me, but still not as quick as it should be. I'm using this to drive better user training in our company (because the slowdown is, in the end, the users' fault). |
|
|
|