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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Any limit to subscribers in one portal?Any limit to subscribers in one portal?
Previous
 
Next
New Post
3/20/2009 9:23 AM
 

Hi, we are using DNN version 4.8.02 and need to know if there exists any restriction or limit of the number of subscribers in one portal, becuase we have more than 200.000.- subscribers in our portal but experience a lot of issues of timeouts, for example: searching "last names" into the users tools we can't do that. Also trying to send massive emails from the admin menu.

Some one can help me to try to figureout this?

Here is the error message trying to find one lastname into the users tool:

ModuleId: 358
ModuleDefId: 15
FriendlyName: Administrar Usuarios
ModuleControlSource: Admin/Users/Users.ascx
AssemblyVersion: 04.08.02
PortalID: 0
PortalName: materna Argentina
UserID: 2
UserName: admin
ActiveTabID: 42
ActiveTabName: Cuentas de Usuario
RawURL: /Admin/UserAccounts/tabid/42/filter/vazquez/filterproperty/LastName/currentpage/1/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.materna.com.ar/Admin/UserAccounts/tabid/42/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; InfoPath.2; OfficeLiveConnector.1.3; OfficeLivePatch.0.0)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 0959fe1b-c349-4997-a025-829719278e0b
InnerException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.GetUsersByProfileProperty(Int32 PortalID, String propertyName, String propertyValue, Int32 pageIndex, Int32 pageSize) at DotNetNuke.Security.Membership.AspNetMembershipProvider.GetUsersByProfileProperty(Int32 portalId, Boolean isHydrated, String propertyName, String propertyValue, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) at DotNetNuke.Entities.Users.UserController.GetUsersByProfileProperty(Int32 portalId, Boolean isHydrated, String propertyName, String propertyValue, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) at DotNetNuke.Modules.Admin.Users.UserAccounts.BindData(String SearchText, String SearchField) in E:\wwwroot\MaternaAR\Admin\Users\Users.ascx.vb:line 274 at DotNetNuke.Modules.Admin.Users.UserAccounts.Page_Load(Object sender, EventArgs e) in E:\wwwroot\MaternaAR\Admin\Users\Users.ascx.vb:line 586 --- End of inner exception stack trace ---
Source:

 

 
New Post
3/20/2009 10:34 AM
 

There are no physical limts but, as you have found, there are performance limits.  You can tune SQL and your server environement for larger sites, but you may also need to modify some of the core for true performance gains.  Simply adding indexes to SQL tables can help.  Maximizing memopry and CPU availability helps.  Reducing the load of other applications, running SQL on a separate server, etc.

Jeff

 
New Post
3/21/2009 11:17 AM
 

Jeff, thanks for your reply!, I add more information for this post...

I have this architecture:

1.- WEB server: Intel Xeon 2 Ghz - 4 Gb RAM - IIS 6.0 - Win 2003 Server
2.- SQL server: Intel Xeon 2 Ghz - 4 Gb RAM - Ms SQL 2005 - Win 2003 Server
Internet broadBand: 2 Mb.-

Can you help me to find out the best configuration of the IIS for this site and wich index need to add (some example)?

Please let me know.

Thanks a lot again!

 

 
New Post
3/22/2009 12:21 AM
 

You might want to dig through the website of the Capital DotNetNuke Users Group (capitaldug.org) to look for references to a presentation that Hal Hayes made to the group at least a year and a half ago.  It had to do with tuning the database for large numbers of users.

If you can't find the presentation (and it might not be there), you at least can contact Hal for information.




Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)
 
New Post
3/24/2009 4:56 PM
 

Are you talking about of this: http://www.halhayes.com/blog/PermaLink,guid,bbb80b64-692f-418b-b31e-28da065ce1a0.aspx, if not how can I contact to Hal Hayes?
I'm trying to find a contact in his blog but I can't :(

Thanks a lot!

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Any limit to subscribers in one portal?Any limit to subscribers in one portal?


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