SIG's Blog

Technology, internet, rants, 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.