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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...big lists in profile properties - slow page!big lists in profile properties - slow page!
Previous
 
Next
New Post
1/9/2008 6:51 AM
 

Hi,

for our students we want to be able to display in profile 2 drop downlists with information from regions and cities from where they should be able to choose first the region and then, based on this choise, the city where they live.

We have successfully populated the lists table, with about 50 regions and about 13500 cities in those regions. Also we have modified the profile to display these regions and cities, similar to the country/region from the default registration.

Now, the problem is that tha page is SLOW to display the profile (~4-5 minutes).The initial page with a default regsion and city is ~150 KB so I do not know why is that slow! Also, based on the region I want to choose a city, but, on postback the page is also slow! Everything else works very fast but this.....SLOW, SLOW....

Help?

Thanks,

Catalin

 
New Post
1/10/2008 5:26 AM
Accepted Answer 

ok.... a little bit of Sql Profiler and Sql Tunning wizard changed the execution of the stored proc. that retrieves the lists from ~2 min to 1-2 seconds...added indexes and statistics.

Catalin

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...big lists in profile properties - slow page!big lists in profile properties - slow page!


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