Entries for September 2011

SQL Server Forward_Only Cursor for Performance 

Posted by Mitchel on Permalink

For those of you that follow me on Twitter you might have heard my recent comments around a DotNetNuke SQL Script that I had to run that would have an impact of between 6 and 9 million SQL statements being executed on a database.  As part of this project I was focusing a lot on SQL Server performance, and getting the best overall bang for the buck with the query. Sadly, given what I was working with a Cursor was needed to ensure that I had the best, most stable solution.  In this post I'll share a little about the process and the lesson learned with cursors.

Read more...

Canonical Portal Alias Woes DNN 5.6.2 

Posted by Mitchel on Permalink

One of the aditions to DotNetNuke 5.x (not sure when/where) was the ability for DotNetNuke to provide a Canonical url in the meta information for your page.  When this all works well, things are going perfectly.  You can configure the site to use the Canonical url via the "Admin Settings" page and normally all works well, but I had a very "interesting" issue with a site recently and I thought I'd share incase anyone else had a similar issue.

Read more...

DotNetNuke 6.0.1 Performance And You 

Posted by Mitchel on Permalink

Now that DotNetNuke 6.x has been out for a while and with the recent release of DotNetNuke 6.0.1 while I was on vacation I thought I'd take the time to write a must requested blog post regarding my thoughts on the DotNetNuke 6.x platform and performance.  Keep in mind, these points are my own personal opinion and should be considered that only, so without further delay.

Read more...

Content provided in this blog is provided "AS-IS" and the information should be used at your own discretion.  The thoughts and opinions expressed are the personal thoughts of Mitchel Sellers and do not reflect the opinions of his employer.

Friend of RedGate

www.datasprings.com - DotNetNuke Modules ICG

Click here for advertising information.

Content in this blog is copyright protected.  Re-publishing on other websites is allowed as long as proper credit and backlink to the article is provided.  Any other re-publishing or distribution of this content is prohibited without written permission from Mitchel Sellers.