Jump to content


How to store click counts by date

  • Please log in to reply
3 replies to this topic

#1 Pythondesigns

  • Members
  • PipPip
  • Member
  • 17 posts

Posted 03 July 2006 - 04:16 PM

Lets say I want to create a click counter. For this click counter lets say there are 300 items which can be clicked on and therefore recorded. I want to be able to record how many clicks are made on each item each day.

What is the best way to store this data in a database?

I was thinking have a table with 3 columns. The columns would be:

Item_ID, Date, Click_Count

When it is clicked then it would check if there is already a date with that item it. If there is then update the row if not insert a new row with the date.

Is this a suitable method?

I want to make sure the method I use is suitable because at a later stage this could be dealing with 20,000+ items.


#2 tfoster

  • Members
  • PipPip
  • Member
  • 10 posts

Posted 03 July 2006 - 04:28 PM

This sounds like an efficient method to me  :)

#3 Pythondesigns

  • Members
  • PipPip
  • Member
  • 17 posts

Posted 03 July 2006 - 04:37 PM

But this would mean for every single item therewould have to be a row for each day.

So for example... lets say if there were 20,000 items which have been there for 3 years... which is 1095 days. That would mean 21,900,000 rows.

That doesnt sound too efficient to me...

#4 birdie

  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts
  • LocationBirmingham UK

Posted 03 July 2006 - 04:51 PM

make a cron job, export the tables every year or so.

Also, you could make it so that the script creates a new table if there are to many rows in the current one? easy job right?

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users