Quote:
Originally Posted by Paul&John
25k posts per day, wow
|
I must have been a little excited. I did a query for the years I have indexed. There may be some mixing items and double parsed items but mostly accurate. It may have peaked on a few days above 10k but that's a ton.
From 2001 to 2011. I picked July 20th, seemed like a busier part but without making a detailed graph it's hard to tell. 2013 and beyond would be more interesting. Anyway here:
Code:
SELECT COUNT(*) FROM thread WHERE year = 2001 AND month = 07 AND day = 20;
Yields: 370 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2002 AND month = 07 AND day = 20;
Yields: 863 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2003 AND month = 07 AND day = 20;
Yields: 2433 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2004 AND month = 07 AND day = 20;
Yields: 5787 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2005 AND month = 07 AND day = 20;
Yields: 5804 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2006 AND month = 07 AND day = 20;
Yields: 7091 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2007 AND month = 07 AND day = 20;
Yields: 3581 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2008 AND month = 07 AND day = 20;
Yields: 1892 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2009 AND month = 07 AND day = 20;
Yields: 2573 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2010 AND month = 07 AND day = 20;
Yields: 2011 unique posts
Code:
SELECT COUNT(*) FROM thread WHERE year = 2011 AND month = 07 AND day = 20;
Yields: 1907 unique posts
Data is wildly off in 2012 and beyond.