Numbers to Prove How Much I Love Skype ChatsPosted: 14/05/2008 | Author: sten | Filed under: In English | Tags: skype, stats | 1 Comment »
Played around with some simple queries in my active Skype chats database, which weighs 215MB in plain text and has data since May 16th 2006. Probably I did a computer migration around then and earlier history (since I started using an early beta of Skype in mid-2003) is buried somewhere in backups.
Found out that I have sent 59709 and received 273715 messages during this time. And respectively 27389 outbound and 140505 inbound messages in the year of 2007. That’s an average of 75 / 385 messages per calendar day. I don’t even want to think if these numbers were my e-mail traffic…
I also found out that a week of vacation has a 5x lowering impact on my Skype communications – 132 messages out /1980 in last 7 days, versus a random weekly sample from a month ago 587 out / 2658 in.
And I also found out that my SQL skills have gone really, really rusty even compared to the mediocre level they used to be at.