Race to post 1,000,000

Question

Race to post 1,000,000

Viewing 15 posts - 61 through 75 (of 129 total)

You must be logged in to reply to this topic. Login to reply

RichardDouglas SSCarpal Tunnel Points: 4029 More actions · Answer 1

CirquedeSQLeil (10/1/2010)
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.

Excellent I'll give it a try when I return from SQLBits.

Thanks Jason,

Rich

Hope this helps,
Rich

[p]
[/p]

george sibbald SSC Guru Points: 104210 More actions · Answer 2

RichardDouglas (10/2/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)
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.
Excellent I'll give it a try when I return from SQLBits.
Thanks Jason,
Rich

sorry, all these nested quoted posts I got confused, what was the question again?

:ermm:

---------------------------------------------------------------------

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

george sibbald (10/2/2010)
RichardDouglas (10/2/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)
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.
Excellent I'll give it a try when I return from SQLBits.
Thanks Jason,
Rich
sorry, all these nested quoted posts I got confused, what was the question again?
:ermm:

Original question was -

"What is the average air speed velocity of an unladen swallow?"

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

george sibbald SSC Guru Points: 104210 More actions · Answer 4

CirquedeSQLeil (10/2/2010)
george sibbald (10/2/2010)
RichardDouglas (10/2/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)
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.
Excellent I'll give it a try when I return from SQLBits.
Thanks Jason,
Rich
sorry, all these nested quoted posts I got confused, what was the question again?
:ermm:
Original question was -
"What is the average air speed velocity of an unladen swallow?"

I'll bite - african or european?

---------------------------------------------------------------------

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

george sibbald (10/2/2010)
CirquedeSQLeil (10/2/2010)
george sibbald (10/2/2010)
RichardDouglas (10/2/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)
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.
Excellent I'll give it a try when I return from SQLBits.
Thanks Jason,
Rich
sorry, all these nested quoted posts I got confused, what was the question again?
:ermm:
Original question was -
"What is the average air speed velocity of an unladen swallow?"
I'll bite - african or european?

What? I don't know that. Aaagghhhh

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

Steve Jones - SSC Editor SSC Guru Points: 736183 More actions · Answer 6

I thought the question was "what is your favorite color?" 😀

Ray K SSC-Dedicated Points: 31163 More actions · Answer 7

Steve Jones - Editor (10/4/2010)
I thought the question was "what is your favorite color?" 😀

Blue! No, yellow!!! AAAAAAAAAAAHHHHHHHHHHHHHHHHhhhhhhh . . . !!!

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

kupy SSCommitted Points: 1652 More actions · Answer 8

I don't know the question, but 42 is the ultimate answer 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Ray K (10/4/2010)
Steve Jones - Editor (10/4/2010)
I thought the question was "what is your favorite color?" 😀
Blue! No, yellow!!! AAAAAAAAAAAHHHHHHHHHHHHHHHHhhhhhhh . . . !!!

Thank ye, I may be singing with Sir Robins minstrels the rest of this day.

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

Ray K SSC-Dedicated Points: 31163 More actions · Answer 10

kupy (10/4/2010)
I don't know the question, but 42 is the ultimate answer 🙂

What do you get when you multiply six by nine?*

(*For the benefit of those of you who didn't read the book -- before you go correcting my math, yes, that's what it says in the book: 6 x 9 = 42!)

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

webrunner SSC-Dedicated Points: 31862 More actions · Answer 11

Looks like it's getting close. Post 1000000 May happen today or tomorrow.

Good luck.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 12

webrunner (10/5/2010)
Looks like it's getting close. Post 1000000 May happen today or tomorrow.
Good luck.
- webrunner

No way... we're only getting a few 100s posts per day.

webrunner SSC-Dedicated Points: 31862 More actions · Answer 13

Ninja's_RGR'us (10/5/2010)
webrunner (10/5/2010)
Looks like it's getting close. Post 1000000 May happen today or tomorrow.
Good luck.
- webrunner
No way... we're only getting a few 100s posts per day.

OK, I see. There are still around 1600 posts to go. I must have overestimated the rate at which they're being added. So maybe it's more like a week away.

Close enough for me to start feeling antsy about it. I can't wait to see who gets the millionth post! 😛

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 14

Well somewhen on october 1st there was ±3000 posts to go.

So that's maybe 400 posts / day on business days.

With those amazingly precise stats :hehe:, we should get there before next monday.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Maybe Steve should post a newsletter item about it and see if there is a sudden influx in posts?

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