View Single Post
  #2 (permalink)  
Old 05-07-2008, 06:21 PM
Tech Manager Tech Manager is offline
WebProWorld Pro
 

Join Date: Jan 2008
Posts: 254
Tech Manager RepRank 1
Default Re: Good idea to track pageviews with MySQL?

Wige:

One of my clients averages about 70,000 hits a day and I store his data in a MySQL database and analyze the data in real time.

Another client averaging about 50,000 hits day relies on a log file and parser. Real time analysis is a bit slower.

I think the higher the data volume the better off you will be to rely on a database instead of a logfile. With the right table design the performance hit has been negligible when analyzing the database in real time.

I prefer the MySQL solution. But of course the typical considerations apply: CPU, RAM, MySQL version, etc.
__________________
I use Country IP Blocks as added security for my networks and servers.
Reply With Quote