Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...tabController.AddTab() gets slow ramdomlytabController.AddTab() gets slow ramdomly
Previous
 
Next
New Post
7/25/2011 5:24 AM
 
cs


Joined: 7/17/2011
Posts: 18
Here's the code I use to create a new page:

    TabController tabController = new TabController();
            TabInfo parent = tabController.GetTab(ParentID, PortalId, false);
   TabInfo newTab = new TabInfo();
            newTab.TabName = pageTitle;
            newTab.Title = string.Format("{0} {1}", " xxxx", pageTitle);
            newTab.ParentId = ParentID;
            newTab.PortalID = ModuleContext.PortalId;
            newTab.IsVisible = false;
            newTab.TabPath = Globals.GenerateTabPath(Null.NullInteger, categoryName);
            newTab.TabPermissions.AddRange(tabController.GetTab(ParentID, PortalId, true).TabPermissions);
            newTab.TabID = tabController.AddTab(newTab);


It works well most of the time; but sporadically my instrumentation (additional debugging code I added to each line) detected that DNN is getting stuck on this line: newTab.TabID = tabController.AddTab(newTab);  for as much as 15 minutes... if I give it enough time it does create the page but I have no idea why it takes that much and it surely works immediately most of the times (less than a fraction of a second) so my question is why is it that the line takes forever sometimes?

Thanks
 
New Post
7/26/2011 4:28 PM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
how many pages does your site have - are all the new pages at the same level or are they are different parts in the hierarchy? Have you tried running a sql server profile trace to see if lots of instructions are happening (e.g. perhaps a hierarchy reorder)?
Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
8/18/2011 3:34 AM
 
cs


Joined: 7/17/2011
Posts: 18
Thanks for your reply Cathal. Almost all pages are at the same level (1) with different Tab Order

This are my table sizes:

TableName / NumberOfRows / reservedSize/dataSize/indexSize/unusedSize
aspnet_UsersInRoles 0           0 KB 0 KB 0 KB 0 KB
PortalSettings 24         16 KB 8 KB 8 KB 0 KB
Store_Reviews 0           0 KB 0 KB 0 KB 0 KB
Forum_ForumPermission 0           0 KB 0 KB 0 KB 0 KB
Profile 171         184 KB 104 KB 32 KB 48 KB
Forum_Polls_Answers 0           0 KB 0 KB 0 KB 0 KB
Forum_Permission 9           16 KB 8 KB 8 KB 0 KB
UserProfile 948         216 KB 112 KB 72 KB 32 KB
Roles 4           64 KB 8 KB 56 KB 0 KB
Forum_Polls_UserAnswers 0           0 KB 0 KB 0 KB 0 KB
UrlTracking 1           32 KB 8 KB 24 KB 0 KB
Wiki_Settings 0           0 KB 0 KB 0 KB 0 KB
UserAuthentication 2           32 KB 8 KB 24 KB 0 KB
Users 192         80 KB 48 KB 32 KB 0 KB
Vendors 0           0 KB 0 KB 0 KB 0 KB
Forum_TemplateTypes 11         16 KB 8 KB 8 KB 0 KB
Events 0           0 KB 0 KB 0 KB 0 KB
UserRoles 396         80 KB 32 KB 48 KB 0 KB
VendorClassification 0           0 KB 0 KB 0 KB 0 KB
EventsCategory 0           0 KB 0 KB 0 KB 0 KB
EventsLocation 0           0 KB 0 KB 0 KB 0 KB
UserPortals 191         48 KB 8 KB 40 KB 0 KB
Forum_Templates 12         32 KB 24 KB 8 KB 0 KB
EventsMaster 0           0 KB 0 KB 0 KB 0 KB
Map_Maps 0           0 KB 0 KB 0 KB 0 KB
UsersOnline 0           0 KB 0 KB 0 KB 0 KB
Blog_Entries 0           0 KB 0 KB 0 KB 0 KB
EventsPPErrorLog 0           0 KB 0 KB 0 KB 0 KB
Map_Providers 6           16 KB 8 KB 8 KB 0 KB
EventsSignups 0           0 KB 0 KB 0 KB 0 KB
Tabs 4804       3360 KB 2720 KB 368 KB 272 KB
Blog_Comments 0           0 KB 0 KB 0 KB 0 KB
NewsCategory 5           16 KB 8 KB 8 KB 0 KB
Map_Sources 0           0 KB 0 KB 0 KB 0 KB
WebServers 5           16 KB 8 KB 8 KB 0 KB
SystemMessages 0           0 KB 0 KB 0 KB 0 KB
Blog_Entry_Categories 0           0 KB 0 KB 0 KB 0 KB
NewsSubCategory 27         16 KB 8 KB 8 KB 0 KB
Skins 15         16 KB 8 KB 8 KB 0 KB
Blog_Categories 0           0 KB 0 KB 0 KB 0 KB
News 4856       19792 KB 19680 KB 16 KB 96 KB
Map_Points 0           0 KB 0 KB 0 KB 0 KB
SkinControls 34         16 KB 8 KB 8 KB 0 KB
Messaging_Messages 0           0 KB 0 KB 0 KB 0 KB
Files 6284       3808 KB 2680 KB 1016 KB 112 KB
FAQs 0           0 KB 0 KB 0 KB 0 KB
SkinPackages 6           16 KB 8 KB 8 KB 0 KB
TabModules 9481       2552 KB 1848 KB 464 KB 240 KB
Blog_Entry_Tags 0           0 KB 0 KB 0 KB 0 KB
Wiki_Topic 0           0 KB 0 KB 0 KB 0 KB
FAQsCategory 0           0 KB 0 KB 0 KB 0 KB
UrlLog 0           0 KB 0 KB 0 KB 0 KB
Blog_Settings 0           0 KB 0 KB 0 KB 0 KB
Wiki_TopicHistory 0           0 KB 0 KB 0 KB 0 KB
NewsAttachedFiles 2649       264 KB 248 KB 16 KB 0 KB
Forum_EmailQueue_Tasks 0           0 KB 0 KB 0 KB 0 KB
Urls 0           0 KB 0 KB 0 KB 0 KB
Blog_Tags 0           0 KB 0 KB 0 KB 0 KB
TabModuleSettings 78         16 KB 8 KB 8 KB 0 KB
Modules 9841       1304 KB 696 KB 472 KB 136 KB
News_RelatedNews 1160       48 KB 32 KB 16 KB 0 KB
Banners 0           0 KB 0 KB 0 KB 0 KB
Packages 135         1600 KB 1480 KB 64 KB 56 KB
SearchItem 4788       3600 KB 3256 KB 248 KB 96 KB
Philip_NewsAudio 0           0 KB 0 KB 0 KB 0 KB
Permission 22         32 KB 8 KB 24 KB 0 KB
MetaData 15         16 KB 8 KB 8 KB 0 KB
ContentItems_MetaData 0           0 KB 0 KB 0 KB 0 KB
Classification 0           0 KB 0 KB 0 KB 0 KB
TabPermission 14343       2288 KB 816 KB 1288 KB 184 KB
Dashboard_Controls 6           16 KB 8 KB 8 KB 0 KB
Feedback 0           0 KB 0 KB 0 KB 0 KB
Forum_EmailQueue_TaskEmails 0           0 KB 0 KB 0 KB 0 KB
Assemblies 83         32 KB 16 KB 16 KB 0 KB
Portals 1           32 KB 8 KB 24 KB 0 KB
Authentication 3           16 KB 8 KB 8 KB 0 KB
ADN_Programs 7           16 KB 8 KB 8 KB 0 KB
Blog_Blogs 0           0 KB 0 KB 0 KB 0 KB
Forum_FilterWords 0           0 KB 0 KB 0 KB 0 KB
Forum_Forums 0           0 KB 0 KB 0 KB 0 KB
ADN_ProgramsAudio 121         32 KB 16 KB 16 KB 0 KB
Forum_Groups 0           0 KB 0 KB 0 KB 0 KB
TabSettings 186         64 KB 56 KB 8 KB 0 KB
EventLog 121         960 KB 912 KB 16 KB 32 KB
aspnet_Applications 1           64 KB 8 KB 56 KB 0 KB
Forum_Moderators 0           0 KB 0 KB 0 KB 0 KB
Help_Category 0           0 KB 0 KB 0 KB 0 KB
Media 2           32 KB 8 KB 24 KB 0 KB
Help_TutorialCategory 0           0 KB 0 KB 0 KB 0 KB
Forum_Moderate_History 0           0 KB 0 KB 0 KB 0 KB
Wiki_Comments 0           0 KB 0 KB 0 KB 0 KB
EventLogConfig 104         32 KB 8 KB 24 KB 0 KB
Forum_Posts 0           0 KB 0 KB 0 KB 0 KB
Help_Tutorials 0           0 KB 0 KB 0 KB 0 KB
ADN_MusicCategory 6           16 KB 8 KB 8 KB 0 KB
Forum_PrivateForums 0           0 KB 0 KB 0 KB 0 KB
Forum_Bookmark_Threads 0           0 KB 0 KB 0 KB 0 KB
AnonymousUsers 0           0 KB 0 KB 0 KB 0 KB
Wiki_CommentParents 0           0 KB 0 KB 0 KB 0 KB
Forum_ThreadRating 0           0 KB 0 KB 0 KB 0 KB
Forum_Threads 0           0 KB 0 KB 0 KB 0 KB
Forum_Avatar_Role 0           0 KB 0 KB 0 KB 0 KB
Xml_Parameter 0           0 KB 0 KB 0 KB 0 KB
Folders 70         48 KB 8 KB 40 KB 0 KB
Forum_ThreadsRead 0           0 KB 0 KB 0 KB 0 KB
FeedbackList 0           0 KB 0 KB 0 KB 0 KB
sysdiagrams 0           0 KB 0 KB 0 KB 0 KB
Affiliates 0           0 KB 0 KB 0 KB 0 KB
Forum_TrackedForums 0           0 KB 0 KB 0 KB 0 KB
Forum_TrackedThreads 0           0 KB 0 KB 0 KB 0 KB
Forum_Attachments 0           0 KB 0 KB 0 KB 0 KB
Forum_PM_Posts 0           0 KB 0 KB 0 KB 0 KB
EventLogTypes 128         56 KB 40 KB 16 KB 0 KB
Forum_PM_Reads 0           0 KB 0 KB 0 KB 0 KB
aspnet_Users 192         104 KB 24 KB 80 KB 0 KB
Forum_Users 0           0 KB 0 KB 0 KB 0 KB
Forum_Emoticons 0           0 KB 0 KB 0 KB 0 KB
Forum_PM_Threads 0           0 KB 0 KB 0 KB 0 KB
Store_OrderStatus 7           16 KB 8 KB 8 KB 0 KB
FolderPermission 348         136 KB 24 KB 112 KB 0 KB
EventsRecurMaster 0           0 KB 0 KB 0 KB 0 KB
PackageTypes 13         16 KB 8 KB 8 KB 0 KB
Store_ShippingRates 0           0 KB 0 KB 0 KB 0 KB
Forum_Post_Reported 0           0 KB 0 KB 0 KB 0 KB
DesktopModulePermission 60         32 KB 8 KB 24 KB 0 KB
ModuleSettings 146         40 KB 24 KB 16 KB 0 KB
News_Feeds 0           0 KB 0 KB 0 KB 0 KB
Links 0           0 KB 0 KB 0 KB 0 KB
aspnet_SchemaVersions 4           16 KB 8 KB 8 KB 0 KB
DesktopModules 74         80 KB 32 KB 48 KB 0 KB
PortalLocalization 4           16 KB 8 KB 8 KB 0 KB
EventsSubscription 0           0 KB 0 KB 0 KB 0 KB
EventQueue 70         184 KB 120 KB 16 KB 48 KB
UserDefinedRows 0           0 KB 0 KB 0 KB 0 KB
EventsNotification 0           0 KB 0 KB 0 KB 0 KB
cs_Comments_Comment 132         232 KB 136 KB 16 KB 80 KB
LanguagePacks 3           32 KB 8 KB 24 KB 0 KB
ModuleControls 270         200 KB 72 KB 80 KB 48 KB
UserDefinedFields 0           0 KB 0 KB 0 KB 0 KB
cs_Comments_GlobalSettings 23         16 KB 8 KB 8 KB 0 KB
Languages 2           32 KB 8 KB 24 KB 0 KB
HostSettings 64         16 KB 8 KB 8 KB 0 KB
Forum_UserForums 0           0 KB 0 KB 0 KB 0 KB
ModuleDefinitions 87         80 KB 24 KB 56 KB 0 KB
Forum_EmailTemplates 19         152 KB 120 KB 8 KB 24 KB
Forum_UserThreads 0           0 KB 0 KB 0 KB 0 KB
UserDefinedData 0           0 KB 0 KB 0 KB 0 KB
HtmlText 33         600 KB 520 KB 8 KB 72 KB
aspnet_Membership 192         160 KB 80 KB 56 KB 24 KB
ModulePermission 88         96 KB 8 KB 88 KB 0 KB
SurveyOptions 0           0 KB 0 KB 0 KB 0 KB
ProfilePropertyDefinition 40         64 KB 24 KB 40 KB 0 KB
Surveys 0           0 KB 0 KB 0 KB 0 KB
Forum_Keywords 32         16 KB 8 KB 8 KB 0 KB
Version 19         32 KB 8 KB 24 KB 0 KB
Blog_MetaWeblogData 0           0 KB 0 KB 0 KB 0 KB
Workflow 2           32 KB 8 KB 24 KB 0 KB
SearchCommonWords 369         32 KB 16 KB 16 KB 0 KB
WorkflowStates 3           32 KB 8 KB 24 KB 0 KB
SearchIndexer 0           0 KB 0 KB 0 KB 0 KB
ContentTypes 2           16 KB 8 KB 8 KB 0 KB
ScheduleItemSettings 0           0 KB 0 KB 0 KB 0 KB
reports_XsltExtensionObjects 0           0 KB 0 KB 0 KB 0 KB
ContentItems 14856       1736 KB 1680 KB 16 KB 40 KB
HtmlTextLog 33         16 KB 8 KB 8 KB 0 KB
Schedule 12         16 KB 8 KB 8 KB 0 KB
HtmlTextUsers 0           0 KB 0 KB 0 KB 0 KB
ScheduleHistory 152         1408 KB 760 KB 48 KB 600 KB
SearchWord 52740       4880 KB 2328 KB 2496 KB 56 KB
Store_Administration 0           0 KB 0 KB 0 KB 0 KB
Store_Cart 0           0 KB 0 KB 0 KB 0 KB
aspnet_Profile 0           0 KB 0 KB 0 KB 0 KB
SiteLog 0           0 KB 0 KB 0 KB 0 KB
Documents 0           0 KB 0 KB 0 KB 0 KB
SearchItemWordPosition 533229     11208 KB 11088 KB 48 KB 72 KB
Store_CartItems 0           0 KB 0 KB 0 KB 0 KB
ContentItems_Tags 0           0 KB 0 KB 0 KB 0 KB
SurveyResults 0           0 KB 0 KB 0 KB 0 KB
SearchItemWord 364526     19600 KB 9032 KB 10408 KB 160 KB
Taxonomy_ScopeTypes 2           16 KB 8 KB 8 KB 0 KB
Store_Addresses 0           0 KB 0 KB 0 KB 0 KB
PortalLanguages 2           32 KB 8 KB 24 KB 0 KB
Taxonomy_VocabularyTypes 2           16 KB 8 KB 8 KB 0 KB
Store_Categories 0           0 KB 0 KB 0 KB 0 KB
Announcements 0           0 KB 0 KB 0 KB 0 KB
PortalDesktopModules 65         32 KB 8 KB 24 KB 0 KB
DocumentsSettings 0           0 KB 0 KB 0 KB 0 KB
Taxonomy_Vocabularies 1           16 KB 8 KB 8 KB 0 KB
Store_Products 0           0 KB 0 KB 0 KB 0 KB
aspnet_Roles 0           0 KB 0 KB 0 KB 0 KB
PortalAlias 1           32 KB 8 KB 24 KB 0 KB
IFrame_Parameters 0           0 KB 0 KB 0 KB 0 KB
Taxonomy_Terms 0           0 KB 0 KB 0 KB 0 KB
Forum_Polls_Polls 0           0 KB 0 KB 0 KB 0 KB
RoleGroups 0           0 KB 0 KB 0 KB 0 KB
Store_Orders 0           0 KB 0 KB 0 KB 0 KB
Lists 396         72 KB 56 KB 16 KB 0 KB
Store_OrderDetails 0           0 KB 0 KB 0 KB 0 KB
 
New Post
8/18/2011 3:39 AM
 
cs


Joined: 7/17/2011
Posts: 18
forgot to mention sqlprofiler does not show anything being executed at the DB level.
 
New Post
8/18/2011 10:00 AM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
there are plenty of pages (almost 5000) but I know of lots of larger installs so I'm not sure what that can be- as it's not reproducible every time all I can suggest is that next time it happens to start a sql profiler session and see if there is lots of database activity -also if you can capture a memory dump (either right click w3wp.exe in task manager and create it or else use a utility such as debugdiag). You can then update this post and I can look into it further.
Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
 Page 1 of 6
123...6Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...tabController.AddTab() gets slow ramdomlytabController.AddTab() gets slow ramdomly


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