Race to post 1,000,000
-
I think it's an int, might be a big int, but we should be fine for years. Surprisingly, a million is a big number when it comes to forums.
-
Steve Jones - Editor (10/1/2010)
I think it's an int, might be a big int, but we should be fine for years. Surprisingly, a million is a big number when it comes to forums.1M posts ya, 1M read, not so much :w00t:
-
I wonder if the rate of posting has slowed since ASKSSC was started?
Interestingly if you view members profile it states that users no of posts out of the total. In there the total is some 8000 less, so which do we believe?
---------------------------------------------------------------------
-
Could be from accounts that Steve has deleted from time to time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
I delete anywhere from 10-50 posts a month from SPAM, so those are likely the issues. I believe this column is an identity, so deletions lead holes.
-
lets celebrate both milestones then! 🙂
---------------------------------------------------------------------
-
I like that idea
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
paul.knibbs (10/1/2010)
Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max value it could have is INT at 2,147,483,647--if it's taken more than ten years to hit a million that suggests there isn't likely to be a problem for another twenty thousand years or so. 😛I bet I could get away with TINYINT on my blog's hit counter!:ermm:
Hope this helps,
Rich[p]
[/p] -
RichardDouglas (10/1/2010)
paul.knibbs (10/1/2010)
Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max value it could have is INT at 2,147,483,647--if it's taken more than ten years to hit a million that suggests there isn't likely to be a problem for another twenty thousand years or so. 😛I bet I could get away with TINYINT on my blog's hit counter!:ermm:
Are you sure about that? How many people read your blog through a feed?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
paul.knibbs (10/1/2010)
Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max value it could have is INT at 2,147,483,647--if it's taken more than ten years to hit a million that suggests there isn't likely to be a problem for another twenty thousand years or so. 😛I bet I could get away with TINYINT on my blog's hit counter!:ermm:
Are you sure about that? How many people read your blog through a feed?
Not many, I had a look at the feedburner stats a little while back. I do get a few hits per day on the actual site, but when you look at the time spent on pages most of them are 0 seconds so presumably it's some kind of cache loading mechanism to speed up people's browser experience. Either that or Google analytics is way off with what it's reporting. Anyone know how Google analyitics works?
Would be interesting to see the stats for this site actually.
Hope this helps,
Rich[p]
[/p] -
RichardDouglas (10/1/2010)
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
paul.knibbs (10/1/2010)
Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max value it could have is INT at 2,147,483,647--if it's taken more than ten years to hit a million that suggests there isn't likely to be a problem for another twenty thousand years or so. 😛I bet I could get away with TINYINT on my blog's hit counter!:ermm:
Are you sure about that? How many people read your blog through a feed?
Not many, I had a look at the feedburner stats a little while back. I do get a few hits per day on the actual site, but when you look at the time spent on pages most of them are 0 seconds so presumably it's some kind of cache loading mechanism to speed up people's browser experience. Either that or Google analytics is way off with what it's reporting. Anyone know how Google analyitics works?
Would be interesting to see the stats for this site actually.
Underpinnings of Google Analytics or just to get it installed in your blog?
I use it and W3Counter stats on my blog. They give me slightly different numbers but it gives a good picture.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
paul.knibbs (10/1/2010)
Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max value it could have is INT at 2,147,483,647--if it's taken more than ten years to hit a million that suggests there isn't likely to be a problem for another twenty thousand years or so. 😛I bet I could get away with TINYINT on my blog's hit counter!:ermm:
Are you sure about that? How many people read your blog through a feed?
Not many, I had a look at the feedburner stats a little while back. I do get a few hits per day on the actual site, but when you look at the time spent on pages most of them are 0 seconds so presumably it's some kind of cache loading mechanism to speed up people's browser experience. Either that or Google analytics is way off with what it's reporting. Anyone know how Google analyitics works?
Would be interesting to see the stats for this site actually.
Underpinnings of Google Analytics or just to get it installed in your blog?
I use it and W3Counter stats on my blog. They give me slightly different numbers but it gives a good picture.
How it qualifies hits, the installation is just adding in an xml file to a certain directory on the site and a filling in some webforms to get it set up at their end.
I might give W3Counter a go next week, do you know if it is something I can have running alongside Google analytics?
To keep things relevant, less than 3000 posts to go !
Hope this helps,
Rich[p]
[/p] -
RichardDouglas (10/1/2010)
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
paul.knibbs (10/1/2010)
Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max value it could have is INT at 2,147,483,647--if it's taken more than ten years to hit a million that suggests there isn't likely to be a problem for another twenty thousand years or so. 😛I bet I could get away with TINYINT on my blog's hit counter!:ermm:
Are you sure about that? How many people read your blog through a feed?
Not many, I had a look at the feedburner stats a little while back. I do get a few hits per day on the actual site, but when you look at the time spent on pages most of them are 0 seconds so presumably it's some kind of cache loading mechanism to speed up people's browser experience. Either that or Google analytics is way off with what it's reporting. Anyone know how Google analyitics works?
Would be interesting to see the stats for this site actually.
Underpinnings of Google Analytics or just to get it installed in your blog?
I use it and W3Counter stats on my blog. They give me slightly different numbers but it gives a good picture.
How it qualifies hits, the installation is just adding in an xml file to a certain directory on the site and a filling in some webforms to get it set up at their end.
I might give W3Counter a go next week, do you know if it is something I can have running alongside Google analytics?
To keep things relevant, less than 3000 posts to go !
I run both at the same time all the time.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
paul.knibbs (10/1/2010)
Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max value it could have is INT at 2,147,483,647--if it's taken more than ten years to hit a million that suggests there isn't likely to be a problem for another twenty thousand years or so. 😛I bet I could get away with TINYINT on my blog's hit counter!:ermm:
Are you sure about that? How many people read your blog through a feed?
Not many, I had a look at the feedburner stats a little while back. I do get a few hits per day on the actual site, but when you look at the time spent on pages most of them are 0 seconds so presumably it's some kind of cache loading mechanism to speed up people's browser experience. Either that or Google analytics is way off with what it's reporting. Anyone know how Google analyitics works?
Would be interesting to see the stats for this site actually.
Underpinnings of Google Analytics or just to get it installed in your blog?
I use it and W3Counter stats on my blog. They give me slightly different numbers but it gives a good picture.
How it qualifies hits, the installation is just adding in an xml file to a certain directory on the site and a filling in some webforms to get it set up at their end.
I might give W3Counter a go next week, do you know if it is something I can have running alongside Google analytics?
To keep things relevant, less than 3000 posts to go !
I run both at the same time all the time.
My god do you really have to add that tracking code to every page?!?!
Hope this helps,
Rich[p]
[/p] -
RichardDouglas (10/1/2010)
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
CirquedeSQLeil (10/1/2010)
RichardDouglas (10/1/2010)
paul.knibbs (10/1/2010)
Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max value it could have is INT at 2,147,483,647--if it's taken more than ten years to hit a million that suggests there isn't likely to be a problem for another twenty thousand years or so. 😛I bet I could get away with TINYINT on my blog's hit counter!:ermm:
Are you sure about that? How many people read your blog through a feed?
Not many, I had a look at the feedburner stats a little while back. I do get a few hits per day on the actual site, but when you look at the time spent on pages most of them are 0 seconds so presumably it's some kind of cache loading mechanism to speed up people's browser experience. Either that or Google analytics is way off with what it's reporting. Anyone know how Google analyitics works?
Would be interesting to see the stats for this site actually.
Underpinnings of Google Analytics or just to get it installed in your blog?
I use it and W3Counter stats on my blog. They give me slightly different numbers but it gives a good picture.
How it qualifies hits, the installation is just adding in an xml file to a certain directory on the site and a filling in some webforms to get it set up at their end.
I might give W3Counter a go next week, do you know if it is something I can have running alongside Google analytics?
To keep things relevant, less than 3000 posts to go !
I run both at the same time all the time.
My god do you really have to add that tracking code to every page?!?!
No - I just installed the plugin and put it on one page. It has taken care of the rest.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 46 through 60 (of 129 total)
You must be logged in to reply to this topic. Login to reply