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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsRepositoryRepositorySlow Performance in 3.01.14 with only 200 Repository itemsSlow Performance in 3.01.14 with only 200 Repository items
Previous
 
Next
New Post
8/20/2008 10:22 PM
 

I am experiencing very slow performance on  3.01.14  of the Repository with only 200 items.  There are a lot of categories, though, and I am not sure if this has an affect.  The site is publicly available, even though unfinished, and can be looked at.  My hosting company has assured me with performance testing that the Web server and database server are not the problem, but that the pages where the Repository module exist are the slowest.  The rest of the site performs fine.  It takes anywhere from 30 seconds to a minute for pages to load that have anything to do with the Repository module...

 

Anyone have any ideas?

 
New Post
8/20/2008 11:55 PM
 

Are you using one of the standard templates? or a custom template?

Can you verify that the 3.01.14 script ran succesfully? specifically the creation of the indexes on the repository categories table?

you can try executing the sproc on the Host->SQL page to see if the problem is in the database or the page. First, determine the module id of your repository module, then try executing this in the SQL page

exec grmGetRepositoryObjects modid, '', 'CreatedDate', 1, -1, '', -1

where modid should be replaced by your module id, and see how long it takes to come back. That will retrieve all repository items for all categories.

If you want to test just a single category, replace the blue -1 in the query with a category id and it will return all the items for that category.

If the query runs relatively quickly, then the problem will most likely be in your page or template so you'll have to look elsewhere. If the query runs longs and appears to be the problem, then you can use some SQL troubleshooting techniques to view the execution plan and make sure your indexes are built properly and being utilized.

 

 
New Post
8/21/2008 10:06 PM
 

The two indexes I have on the grmRepositoryCatgegories table are IX_grmRepositoryCategories(Non-Unique, Non-Clustered) and PK_grmRepositoryCategories(Clustered).  There are no indexes on the grmRepositoryObjectCategories table.

I executed that sproc and it took 9 seconds to return 206 items.

I am going to investigate the lack of indexes on that one table a bit further.

 
New Post
8/22/2008 10:04 PM
 

Michael Sumerano wrote

I am going to investigate the lack of indexes on that one table a bit further.

I looked at the 3.01.14 script and I didn't see any index creation scripts for the grmObjectRepositoryCategories table.  Not sure if this is what you meant.

 
New Post
8/24/2008 11:10 AM
 

Hmm... this particular sproc uses a CURSOR, so, even with indexes, I am not surprised that it takes 4-6 seconds to return 206 records.  I checked the execution plan and it is using the indexes.  It's using a cursor to do a keyword search, it seems.  I know there are more efficient ways to do this.  Any chance of getting this fixed before the 4.0 version gets released?  I really can't wait.  If I get a chance, I can probably look at it, but was just wondering if this was on the radar.

Maybe this?

http://www.sqlteam.com/article/keyword-search-using-a-tally-or-sequence-table

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsRepositoryRepositorySlow Performance in 3.01.14 with only 200 Repository itemsSlow Performance in 3.01.14 with only 200 Repository items


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