Cooking with SQL - TinyStats Performance Boost

TinyStats Performance Boost

Written by Datagod

Thursday, 08 November 2007

Over the past few weeks I have been thinking about how to further crunch the TinyStats weblog data in order to increase performance of my Grand Summary reports.

Currently I have about 500,000 records in my WebLog table. This translates into 150,000 WebLogFact records. The fact table works great for detailed reports, but for grand total reports it can be a bit cumbersome.

My new report table summarizes the number of hits per domain per day. This information is broken down by visitor type. The table does NOT contain URL information, IP Address information or Machine Address information. This new table contains approximately 2500 records which is considerably smaller than the WebLogFact table.

Needless to say, the Grand Summary report is an order of magnitude faster than it was before.

I am hoping to be able to devote more time to my TinyStats project during the Christmas Holidays. I want to go public but I must be certain my database schema and reporting structure can handle large volumes.

Until then, stay tuned. If you want to take part in the beta test, send me an This e-mail address is being protected from spam bots, you need JavaScript enabled to view it . I would love to have more testers!

Comments (2) add comment

Subscribe to this comment's feed

Mike Hurley said:

	I would like to beta test TinyStats, but I could not find your email address. I have been looking for a stats program like TinyStats for a long time, so if you're interested, please email me at This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
	report abuse vote down vote up