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
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListQuicken Page - F&L Module - LOTSA recordsQuicken Page - F&L Module - LOTSA records
Previous
 
Next
New Post
5/15/2012 1:12 PM
 
Jeff M.


Joined: 7/30/2009
Posts: 422

Hello..
Thought I would just throw this out here for suggestions.

We have a records look-up page and we've added all but 39 records.  Thus far, there are 61,803 rows for this one module in our UDT table; there are 4698 total records thus far.  The information isn't storing anything exorbitant; see below for what one record shows within the DB.

When I first visit the page, it takes 12 seconds for the page to come up (not bad for these many records, but I know there will be complaints when it goes live).

My question is, how can we quicken the load time of the page?  Is there a way to have the F&L module only query for the latest volume and display only those items instead of querying all the module records?  There's a search bar at the top so people can search for and find a certain volume, plat name, etc.

Thanks..

Field Title FieldValue userDefinedFieldID
Changed at 2012-05-04T12:42:25 632
Changed by DNNUser 633
Created at 2012-05-04T12:42:25 634
Created by DNNUser 635
Plat Name Butler Survey 636
Owner Name Butler, Samuel 637
Municipality Troy 638
Tract 1,3 639
Section 13 640
Lot 74,75 641
File Date 4/13/1854 642
Volume 1 643
Page 1 644
File Name FileID=14510 645
Size [File:Size|#,### bytes] 646
 
New Post
5/15/2012 2:55 PM
 
Stefan Cullmann


Stefan Cullmann's Avatar

Joined: 1/6/2005
Posts: 2867

Hi Jeff,

I am afraid there is nothing you can do to tweak the performance without changes to the module itself.

 I've got a lot of proposals over the last years, which always solved one aspect of the problem. Currently I think the best way would be to cache the data in a state which is independent from current context (e.g. the current user), and to withdraw it after write actions.

 Sorry,
Stefan
 
 Page 1 of 1
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListQuicken Page - F&L Module - LOTSA recordsQuicken Page - F&L Module - LOTSA records


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