Professional Website Design, Development and Hosting for DNN / WordPress


SIG's Blog


Technology, internet, rants and raves.

Pruning the DNN user tables
The odds are that if you've had user registration open for any great length of time that you'll have some users that haven't logged in for for years, or others who logged in once and never came back. A recent project to optimize an installation of DNN involved doing an inventory of the DNN user tables to see if there were opportunities for a performance improvement by winnowing out inactive or rogue user accounts from the installation. The site had collected 111,751 users in the five years of operation, not an unruly number at all but still worth investigating. Another factor at play was the sheer volume of traffic. On average, there were 1.5 million page views per month being generated by 275,000 users. After running various queries against the tables and reviewing the user-centric areas of the site, a surprising 72,963 users were identified as being candidates for removal.

Terms Of Use  |  Privacy Statement
Copyright (C) 2018 Swanzey Internet Group LLC. All Rights Reserved.