Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...DNN Platform (o...DNN Platform (o...DNN 5.1.2  - UserController.GetUsers(PortalId,True,True) generate to much calls to DBDNN 5.1.2 - UserController.GetUsers(PortalId,True,True) generate to much calls to DB
Previous
 
Next
New Post
1/13/2010 3:57 AM
 

How to get User List of the portal from DNN Cache?

---------------------------------------------------------------------------------------

'Dim uc As New UserController ' too much calls to DB (UserInfo)
'userList = uc.GetUsers(PortalId,True,True)

go
exec dbo.GetUserProfile @UserID=3
go
exec dbo.aspnet_Membership_GetUserByName @ApplicationName=N'DotNetNuke',@UserName=N'XXXXXXXX',@UpdateLastActivity=0,@CurrentTimeUtc='Jan 13 2010  8:47:13:743AM'
go
exec dbo.aspnet_Membership_GetUserByName @ApplicationName=N'DotNetNuke',@UserName=N'XXXXXXXX',@UpdateLastActivity=0,@CurrentTimeUtc='Jan 13 2010  8:47:13:743AM'
go
exec dbo.GetUser @PortalID=0,@UserID=3
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserCountByPortal @PortalId=0
go
exec dbo.GetUserProfile @UserID=3
go
exec dbo.aspnet_Membership_GetUserByName @ApplicationName=N'DotNetNuke',@UserName=N'XXXXXXXX',@UpdateLastActivity=0,@CurrentTimeUtc='Jan 13 2010  8:47:13:773AM'
go
exec dbo.aspnet_Membership_GetUserByName @ApplicationName=N'DotNetNuke',@UserName=N'XXXXXXXX',@UpdateLastActivity=0,@CurrentTimeUtc='Jan 13 2010  8:47:13:773AM'
.....................................

 
New Post
1/13/2010 11:49 AM
 

Since you are looking for hydrated user objects, this is going to be a bit more database heavy.

Secondly, I do not believe that DNN would cache the entire user list at any time, from a scalability standpoint that would not be helpful for the platform.


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
1/21/2010 11:35 AM
 

I can't understand why  each calls to dbo.aspnet_Membership_GetUserByName   generate ~20 calls to dbo.GetUserCountByPortal @PortalId=0
 (return UserCountByPortal)

 
New Post
7/29/2010 3:04 PM
 
I'm with you Evgeny, I don't understand it either and find it irritating.
 
New Post
3/28/2011 11:07 AM
 
I thought this was fixed in 5.2.1? I am seeing the same issue in 5.31 currently on a Dev box I have running. It is running a lot more that 20 times. I did notice that the providers are still listed as 5.2.0 with the 5.31 one upgrade package. Is that correct?
 
Previous
 
Next
HomeHomeDevelopment and...Development and...DNN Platform (o...DNN Platform (o...DNN 5.1.2  - UserController.GetUsers(PortalId,True,True) generate to much calls to DBDNN 5.1.2 - UserController.GetUsers(PortalId,True,True) generate to much calls to DB


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out