Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Products › Development › Forge › Module - Reports Register  |  

  Quick Links  
 


  Team Leadership  

 

Andrew Nurse
( Team Leader )

 
 


  Team Members  
 


  DotNetNuke Projects  
The DotNetNuke Projects are a special category of platform extensions which are developed by volunteers to conform to the high professional standards mandated by DotNetNuke Corporation. The DotNetNuke Projects are distributed as a standard part of the DotNetNuke core application release offerings.
 


$4.95 Windows Hosting at Webhost4life.com
  Ads  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  Sponsors  

Meet Our Sponsors

ExactTarget email software solutions
Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
Salaro -- Skins and more
OnyakTech
 


DotNetNuke® Project :: Reports Module

The Reports module provides a simple, but flexible, view on data from your DotNetNuke Database. SuperUsers (aka "Host" users) can develop Reports by building a SQL Query and visualizing it with one of the Visualizers built-in to the module or a 3rd-party Visualizer.

How can you use the Reports Module?
  • Display a table of custom data from your Database
  • Display a list of Users in a specific Role
  • Display advanced queries that pull data from multiple tables
  • Display a chart of the number of users in each role
  • Display a report from SQL Reporting Services (EXPERIMENTAL)
Features: What can the Reports Module do now?
  • Display the results from any SQL Query in one of many ways:
    • a Grid
    • a Chart
    • an HTML-based template
    • an XSLT-based transformation
    • or anything else you want with the extensible Visualizer framework
  • Display reports from SQL Reporting Services
  • Import/Export Report Definitions through standard Import/Export Content
Roadmap: What are the future plans for the Reports Module?
  • Full support for the ASP.Net ReportViewer Control and SQL Server Reporting Services
  • Custom Parameters such as @PortalID, @TabID, @UserID that are filled in when the query is run
  • Custom Data Sources to enable the module to display reports containing data from:
    • Your DNN Data Provider
    • Other SQL-based Databases
    • XML Data
    • UDT Module Data
  • Allow SuperUsers to predefine a set of Reports that Admins can use (at this time, only SuperUsers can create Reports)
The project can be downloaded here
 


View_Blog

Improving Performance in 3.3/4.3

Jun 27

Posted by: Charles Nurse
6/27/2006 

Many people have commented that the dotnetnuke.com site is a little slower with the recent upgrade to 4.3.1 (especially for Login).

If your site has a lot of users, you are probably getting the same "poor" performance.  (Note - the problem is not confined to 4.3.1 - it will also be a problem with 3.3.1, as it is due to one of the new User features).

However, there is a simple solution, and here it is.

1. Log in as admin or host
2. Go to the "User Accounts" module (on the Admin menu).
3. Select the "User Settings" module action
4. Click Update to save the Settings.

Savvy users will have by now figured out the problem - The User Settings, which are implemented as Module Settings in the Database do not exist (are null).  Loading the User Settings page loads the default values and clicking "Update" persists them to the database.

Normally, when custom Module Settings are not "set" this does not affect performance but in this case there is a very expensive query that is run when retrieving the default settings.  This query will run every time a setting is needed, because, the GetSetting uses a fallback approach:

a) - try fetching the settings from the Cache
b) - try fetching the settings from the Database
c) - load the default settings (which calls the expensive query GetUserCountByPortal)
d) - get the setting from the collection of settings

On this site, when logging in, 3 different settings are needed, so the query is made 3 times - at a cost of about 800ms each (due to 300,000 users), hence the performance issues.

Now that I have carried out the procedure above (1-4) on this site, the default settings have been persisted to the Database, and the caching mechanism can work -  Login is much faster.

A fix will be added to the next version, so that default values are automaticaly saved to the database on upgrade (or first access).

Trackback Print
Location: Blogs Charles Nurse
Tags:

8 comment(s) so far...

Re: Improving Performance in 3.3/4.3

Good job Charles!

By rodneyjoyce on   6/27/2006

Re: Improving Performance in 3.3/4.3

How come when I go to
Go to the "User Accounts" module (on the Admin menu).
I do not see
Select the "User Settings" module action

By boatczy on   6/27/2006

Re: Improving Performance in 3.3/4.3

Boatczy: Depending on the skin you're using, you should see the "User Settings" as one of the items in the drop-down list to the left of the "User Accounts" container title bar.

By Rask on   6/27/2006

Managing Profile Properties

Registration form By mombassa on 6/28/2006
Hi,

I've modified the profile properties and added a field. When I add the User Account module to a page, it still shows the old fields. Or am I misunderstanding the purpose of "Manage Profile Properties"?

Thanks for any help,
chris

By mombassa on   6/28/2006

Re: Improving Performance in 3.3/4.3

I don't see the 'User Settings' module action. I only have 'Add User', 'Help' and 'Online Help'. What gives?

By bnsc on   6/28/2006

Re: Improving Performance in 3.3/4.3

mombassa - I think the User Account Module is still configured to use the old registration control. Use Module Definitions and change the User Account to use

Admin/Users/ManageUsers.ascx

instead of

Admin/Security/Register.ascx

By cnurse on   6/28/2006

Re: Improving Performance in 3.3/4.3

Charles, thanks!

By mombassa on   6/29/2006

Users self Managing Profile Properties

I am having the same problem as mombassa (new profile properties do not show up on the User Account module's Manage Profile Properties page) on DNN 4.4.1. I have checked and the module definition already is set to 'Admin/Users/ManageUsers.ascx'.

Thanks for any help...

By RBarryYoung on   5/9/2007
 


Convert Visitors to Customers
In order to bring value to your users, we must first understand them. VIVIDSITES will help you build a custom web application and interactive marketing tools that your users will thank you for. We marry high-end creative with head banging technology to entertain and convert visitors into paying customers. Call 314.514.0505 or visit us at http://www.vividsites.com to find out how.
- V I V I D S I T E S - 		Gearworx Web Hosting
As a premier provider of Web Hosting, Private/White Label hosting, Server Colocation, Dedicated Server, and other Managed Services, Gearworx offers an array of services designed to more effectively manage strategies driving businesses on the Web. Headquartered in Fremont, California our state of the art tier one data centers and distributed managed services environment enables Gearworx to offer your business enterprise level solutions through simplified processes.
Gearworx Web Hosting 		Glanton: Enterprise Intranet Specialists Using DNN
Glanton Solutions are a premier provider of sevices for large corporates lloking to outsource Intranet sites.
www.glanton.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP