On Mon, Feb 16, 2009 at 7:18 PM, Miles J <[email protected]> wrote:
>
> Well you could save each download with a date...

Yeah, this is what I'm saying--that, if a date is required, then
simply incrementing a single field in the files table will not work
and there needs to be a downloads table. The bonus is that you can
then save all sorts of other info, as well.

> and have a monthly
> cron that runs, calculates the total for that month and saves it to
> another table for monthly statistics, then erase all the previous
> single date records. But unless your doing by day, week, time etc,
> that wouldn't work.

If you only ever have a single data point for a month you'd limit your
ability to generate stats. All you'd have is that one total. Anyway,
in order to do this, you'd still need to save a record for each
download, rather than incrementing a field for a particular files row.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to