Tuesday, January 06, 2009     | Register
To start or answer a thread you will need to login...


Forum Guidelines

Please ensure you follow the bug-raising guidelines (e.g. post the full error from your Event Viewer) if you are raising a support call. To request a feature in a module, please use Feature Requests (unless you want to discuss it here in more detail first). If you have an urgent feature that you would like to see in the product then you should consider a Sponsored Enhancement.

 

First Time User? Make sure you have read the Module Config Guide in the documents folder of each module. Also check out this handy Module Deployment Guide (written by a Smart-Thinker customer!)

Configuration issues and no time to read the Forums/Documentation? See our DotNetNuke Premium Support Service.

 

We need your opinion! Please read our proposed new CrowdSourcing development method and let us know if you would be interested and if it might work.

 
 
  Forums  DotNetNuke  Smart-Thinker U...  Performance User Profile 4.3.13 - terribly slow and errors
Previous Previous
 
Next Next
New Post 10/31/2008 3:43 AM
Resolved
  nahodo
8 posts
5th Level Poster


Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

Dear all,

I am currently working with the trial version of this module and want to make sure that the integration in my portal works.

Well, I experience the following:

- The Userprofil - Profile module can't be configured because everytime I am trying this a time-out occurs.

- The Userprofil Module is so slow. When I call the site with the module, it needs 1-2 minutes after I got the result. In the beginning, with 10 users there where no problems. After a bulk import of additional 4000 user the problems occur.

I really need help and appreciate your answers.
Thanks

Nam

 

 

 
New Post 10/31/2008 10:14 AM
  nahodo
8 posts
5th Level Poster


Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

Well, I figured out the problem but I am not able to fix it. Everytime when a module is started a procedure loops through all user!

It executes the SPs:


 exec dbo.aspnet_Membership_GetUserByName @ApplicationName=N'DotNetNuke',@UserName=N'speo',@UpdateLastActivity=0,@CurrentTimeUtc=''2008-10-31
   
exec dbo.GetUserProfile @UserID=652   

 

Both 4800 times, the amount of my users. The execution takes 20ms per user --> 20ms * 4800 = 96 sec (!)-> nearly 1,5 minutes.

That is strange - is that mandatory? Even if I only want to change the option of a Smart Thinker module like group, userprofile the procedure is running. Am I the only one with a portal with >1000 users? I don't think so!

 

Thaks for helping me,

Nam

 
New Post 10/31/2008 3:46 PM
  Rodney Joyce
3064 posts
www.DNNDir.com
1st Level Poster




Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)
Modified By Rodney Joyce  on 10/31/2008 4:47:58 PM)

Hi,

So just to clarify - is performance issue is only on the Settings page or when a normal user views a profile?

 

I am aware of all users being loaded when Settings are changed for admin. I have over 35k of users on PokerDIY but my Settings page is still usuable (it sometimes timesout with an AJAX error when I try to save). It's one of those lines of code from 3 years ago that I knew would cause a headache but never had time to change!

 

The good news is that it will be fixed in the latest version. Instead of loading a dropdownlist of all possible users there will just be a textbox for the UserID if you want to set the profile to a preset user. This should be out in the next week - let me know if you need it more urgently.

 

I need to know if this is not a Settings issue though.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 10/31/2008 4:51 PM
  nahodo
8 posts
5th Level Poster


Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

Hi Rodney,

thanks for your answer.


Well, I traced the SQL in the different bottle neck situations.

Also in the case of trying to load the settings of the module UserProfile (where afaik no user can be selected or will be displayed) the users are loaded.

I don't mind, but why do I have this problem and apparently nobody else - with 5k users? It works fine on your portal with 35k users.

Are 20ms to slow for processing one user?

 

But the most interesting thing. Even if I am logged on as normal user, I normally only see my data (no selection of other user). Here the behaviour is the same - loading all user with the two mentioned SPs!

I am really getting mad.... I want to use these great modules :-)))

Looking forward to your answer!

Thanks,
Nam

 
New Post 10/31/2008 5:34 PM
  nahodo
8 posts
5th Level Poster


Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

apparently it doesn't occur when you want to change settings of the userprofile module. But it occurs in the "userprofile - profile" module.

 

Just to make it clear - if this only occurs in the settings (hopefully without time out) it is accetable. But the pain is that a normal user (just see his own data) loads all user in the background and this is a show stopper for my page (because of the loading time of nearly 1,5min).

So, interim conclusion:

- admin pages with user drop downlist --> slow

- settings sometimes causes time out (because of long loading time)

- user access page with userprofile module (not the userprofile - profile) has painful loading times as well, because of the unnecessary loading of all users in the background

 

I create a test site (blank site, only your modules and the 4500 user) - same issue. I thought that my index on the relevant tables were broken and causes these running times but to be honest - 20ms are not that much.

Or do you experience other running times?

But why does nobody have this problem? I read nearly all posts in the forum....

:-(

kr

Nam

 

 

 
New Post 10/31/2008 6:08 PM
  Rodney Joyce
3064 posts
www.DNNDir.com
1st Level Poster




Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

Hi Nam,

Ok, Iam only aware of the Settings issue (the profile loads fine with me) - but save yourself some time/pain and leave it with me - I'll have a look at it tomorrow (I am releasing a new version of the UP module next week).

It is very odd that it occurs when viewing a profile as this should definitely not happen (for example, with my 35k of users, the pagesize is 1.5 meg ;) This will change in the next version but the profiles load fine (e.g new player)

Are you logged in as Admin or a normal user when viewing your page (try both please).

If you do a View Source can you see a long list of users, and if so, what is generating it. Can you also let me know exactly what modules you have on your page.

If you could answer those questions it will help me get to the bottom of it tomorrow..

 


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 10/31/2008 6:19 PM
  nahodo
8 posts
5th Level Poster


Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

Hi Rodney,

thanks for taking care of this problem. I am really looking forward to the new version...

I tried both (Admin /normal user).

Currently, I got a time-out in trying to save a setting in the module "Smart-Thinker - UserProfile - Profile".

The lists shows you the following thing (admin mode) - just an abstract:

I also changed the user ids to "xx"

<td><select name="dnn$ctr452$ModuleSettings$SettingsUserProfile$cmbUser" id="dnn_ctr452_ModuleSettings_SettingsUserProfile_cmbUser" class="NormalTextBox" style="width:300px;">
<option value="-2">Random User</option>
<option value="-1">Passed-In UserID</option>
<option selected="selected" value="-3">Logged On User</option>
<option value="xx">#rob</option>
<option value="xx">**Anna**</option>
<option value="xx">*Anna*</option>
<option value="xx">*Dan*</option>
<option value="xx">*eva*</option>
<option value="xx">*Kiki*</option>
Well, nothing suspicious, I guess.
I use some modules on my page like active forums etc. But on the blank site I only had the smart thinker modules and the bulk import module for importing all the users.
 
Actually, I can also give you host access to my page if this helps to evaluate the error. Furthermore, I can also give you the bulk import module "Bulkuser manager 2" and a source file to import
user to a blank site and than trying to work with smart thinker modules. I promise you will experience the same issues..
Again, looking forward to your answer tomorrow. You know, in Germany it is currently 1:15 a.m - another sleepless night because of DOTNETNUKE issues :-)
 
best regards,
Nam
 
New Post 11/2/2008 8:31 AM
  nahodo
8 posts
5th Level Poster


Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

Hi Rodney,

are there any results concerning this issue? I still hope that this will be fixed in the release next week....

 

;-)

kr

Nam

 
New Post 11/2/2008 2:43 PM
  Rodney Joyce
3064 posts
www.DNNDir.com
1st Level Poster




Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

Hi Nam,

 

I've fixed the settings issue (it now uses a textbox for the preset UserID) and have got this thread on my list for the next 2 days. I should have something for you to try on Tues or Wednesday, but rest assured I am lookling at it. I can't imagine why it would read ALL users with a simple view of a single profile -there is no code I know of that does it so I will run Profiler on it later.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 11/2/2008 2:46 PM
  Rodney Joyce
3064 posts
www.DNNDir.com
1st Level Poster




Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

ps - please answer this questions as they are the most important in helping me track down the problem:

If you do a View Source can you see a long list of users, and if so, what is generating it.   * Can you do this as a normal user, viewing a profile

If you can run profiler when logged on as a normal user can confirm that it hits ALL user records that would be useful too please.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 11/2/2008 10:50 PM
  nahodo
8 posts
5th Level Poster


Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

Hi Rodney,

 

thanks for fixing the settings issue.

O.k, here is the answer on your questions:


Admin Mode:

- Long list of users (when drop downlists with users is created) in html source - like mentioned above - (ok I think) -> long loading time, not good but reasonable

User Mode:

- no list of users in the source code, but loading of users in the background anyway (see trace) --> long loading time, not reasonable

 

I'll send you some screenshots via email later.

 

thank you very much,

Nam

 

 

 
New Post 11/5/2008 6:42 PM
  Rodney Joyce
3064 posts
www.DNNDir.com
1st Level Poster




Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

I just want to capture our exchange for all users here:

Nam has sent me the screenshots and the following performance issues have been noted and will be fixed in the upcoming release (1-2 days hopefully).

  1. Module Settings Edit on UserProfile Profile View
  2. Edit Profile View
  3. Group Edit (fixed in next groups release)

This will only affect you if you have a large number of users on your site (over 4k at least - I have 35k on PokerDIY and it is useable still, but slow). It also depends on the speed of your Host and your internet speed.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 11/7/2008 9:51 PM
  Rodney Joyce
3064 posts
www.DNNDir.com
1st Level Poster




Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

Smart-Thinker UserProfile version 4.3.14 has now been released and fixes issue 1 and 2.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 11/9/2008 3:07 PM
Accepted Answer 
  nahodo
8 posts
5th Level Poster


Re: Performance User Profile 4.3.13 - terribly slow and errors  (N/A)

 Rodney Joyce wrote

Smart-Thinker UserProfile version 4.3.14 has now been released and fixes issue 1 and 2.

Well, as Rodney said- the issues are fixed. Excellent work.

Thanks,
Nam

 
Previous Previous
 
Next Next
  Forums  DotNetNuke  Smart-Thinker U...  Performance User Profile 4.3.13 - terribly slow and errors
Top Threads
In the past 1 week, we have 20 new thread(s) and 63 new post(s)
The most popular thread has been Re: Sponsored Enhancement Proposal Estimate - StoryFeed Commenting
The most active thread has been Sponsored Enhancement Proposal Estimate - StoryFeed Commenting
Smart-Thinker is powered by DotNetNuke - please support us and DotNetNuke - DotNetNuke Powered!
© 2008 Smart-Thinker   |  Privacy Statement  |  Terms Of Use