planning database maintenance heres some inactivity stats from cbhours

[cbhours]

I'm planning database maintenance on the giant cbhours archive because after 4 years it's getting excessive so I created a report to give me information. I ran the report by first character of the models name so thats why its divided like that but i thought i'd leave that information there just incase someone cares to see it.

Inactive CB Model Analysis Report (Inactive or disabled appear on network sites for over a year)​

Overall Statistics:

Total Models Seen in 4 Years:	2,042,044
Inactive Models:	1,415,328
Inactive Percentage:	69.31%

Key Insights:

• [] Highest inactivity: Models starting with '_' at 76.06%[] Lowest inactivity: Models starting with '7' at 62.42%[] Highest volume first characters: 's', 'a', 'm' (over 170k models each)[] Overall inactivity rate across all first characters: 69.31%

Complete Inactive Model Data (Sorted by Inactivity Percentage):

First Character	Total Models	Inactive Models	Inactive %
_	27,425	20,860	76.06%
k	83,762	60,050	71.69%
a	177,339	126,728	71.46%
v	39,290	28,066	71.43%
l	130,618	92,045	70.47%
x	17,772	12,487	70.26%
s	216,801	151,900	70.06%
c	132,930	93,014	69.97%
n	64,078	44,750	69.84%
e	67,153	46,788	69.67%
2	3,243	2,259	69.66%
m	177,533	123,275	69.44%
y	22,292	15,346	68.84%
q	5,494	3,781	68.82%
9	1,139	779	68.39%
d	105,208	71,947	68.39%
h	72,931	49,854	68.36%
i	38,797	26,499	68.30%
p	72,582	49,517	68.22%
b	133,142	90,692	68.12%
z	14,321	9,721	67.88%
j	100,544	68,187	67.82%
t	96,155	65,144	67.75%
r	64,100	43,354	67.63%
g	51,808	34,878	67.32%
1	5,106	3,436	67.29%
f	49,613	33,222	66.96%
w	28,763	19,257	66.95%
5	720	479	66.53%
6	2,290	1,515	66.16%
o	20,903	13,794	65.99%
3	1,239	814	65.70%
4	1,796	1,165	64.87%
u	11,376	7,319	64.34%
0	1,448	929	64.16%
8	1,218	781	64.12%
7	1,115	696	62.42%
OVERALL	2,042,044	1,415,328	69.31%

Top 10 First Characters by Model Volume:

First Character	Total Models	Inactive Models	Inactive %
s	216,801	151,900	70.06%
m	177,533	123,275	69.44%
a	177,339	126,728	71.46%
b	133,142	90,692	68.12%
c	132,930	93,014	69.97%
l	130,618	92,045	70.47%
d	105,208	71,947	68.39%
j	100,544	68,187	67.82%
t	96,155	65,144	67.75%
k	83,762	60,050	71.69%

Edit: Edited to be clear that this is total models seen in 4 years.

 

[cbhours]

I will also post this because i figure someone may want to know, here are the numbers of the people that havent been online in a month (starting from a month ago because archive doesnt contain the current month).

Monthly Inactive Model Analysis Report​

Overall Statistics:

Total Models Seen in 4 Years:	2,042,044
Inactive Models (1 month):	1,861,949
Monthly Inactive Percentage:	91.18%

Key Insights:

• [] Highest inactivity: Models starting with '9' at 92.19%[] Lowest inactivity: Models starting with '0' at 89.16%[] Highest volume first characters: 's', 'a', 'm' (over 170k models each)[] Overall monthly inactivity rate across all first characters: 91.18%
• The monthly inactivity rate (91.18%) is significantly higher than the overall inactivity rate from the previous report (69.31%)

Complete Monthly Inactive Model Data (Sorted by Inactivity Percentage):

First Character	Total Models	Inactive Models	Inactive %
9	1,139	1,050	92.19%
k	83,762	76,932	91.85%
2	3,243	2,977	91.80%
7	1,115	1,022	91.66%
c	132,930	121,783	91.61%
_	27,425	25,124	91.61%
v	39,290	35,936	91.46%
a	177,339	162,131	91.42%
d	105,208	96,134	91.38%
b	133,142	121,630	91.35%
l	130,618	119,322	91.35%
3	1,239	1,131	91.28%
5	720	657	91.25%
x	17,772	16,216	91.24%
s	216,801	197,778	91.23%
j	100,544	91,633	91.14%
r	64,100	58,400	91.11%
t	96,155	87,573	91.07%
m	177,533	161,686	91.07%
1	5,106	4,650	91.07%
n	64,078	58,347	91.06%
f	49,613	45,148	91.00%
h	72,931	66,354	90.98%
6	2,290	2,083	90.96%
p	72,582	66,013	90.95%
e	67,153	60,975	90.80%
g	51,808	47,016	90.75%
y	22,292	20,190	90.57%
w	28,763	26,047	90.56%
q	5,494	4,974	90.54%
4	1,796	1,624	90.42%
i	38,797	35,070	90.39%
z	14,321	12,940	90.36%
o	20,903	18,872	90.28%
8	1,218	1,090	89.49%
u	11,376	10,150	89.22%
0	1,448	1,291	89.16%
OVERALL	2,042,044	1,861,949	91.18%

Top 10 First Characters by Model Volume:

First Character	Total Models	Inactive Models	Inactive %
s	216,801	197,778	91.23%
a	177,339	162,131	91.42%
m	177,533	161,686	91.07%
b	133,142	121,630	91.35%
c	132,930	121,783	91.61%
l	130,618	119,322	91.35%
d	105,208	96,134	91.38%
j	100,544	91,633	91.14%
t	96,155	87,573	91.07%
k	83,762	76,932	91.85%

Edit: these numbers are probably more in line with what everyone was expecting, the first post includes models that started in the last year so that throws everything off.