Of course if all you want is stats on the file downloads and your server does that anyway, why not just filter/ collect stats from the log files?
Sam D On Tue, Feb 17, 2009 at 2:04 AM, Mike Cook <[email protected]> wrote: > > Okay, definitely some food for thought here. > > @Miles J :: As brian states, this would be for stats. It's okay > knowing you have 10 downloads, but knowing the time, day, week, and > month can help in understanding your visitors better. If I do get to > the point of implementing an API then I should also be able to record > which party is drawing which downloads. So on and so forth. > Recording milestones could work, but then I would loose all that > lovely data. To help in page load time I guess I could just gather the > file and author totals for the frontend on a daily/weekly basis - I > don't suppose my visitors would mind/notice :) > > @Alfredo Quiroga-Villamil :: I've only done some small DB projects > before so I'd have to look into this further, but if I want to start > recording other data then this might become a mute point. > > @brian > >> Tens of thousands of updates in a month shouldn't be a problem. I know >> it's all relative, but a table with several thousand records is quite >> tiny, btw. There are apps out there running Postgres or MySQL that >> have many hundreds of millions of records. And, which have tens of >> thousands of updates in a day, if not an hour. > > My DB experience is quite limited so this is good to know. > >> If you're using MySQL, you could consider the innodb engine. The >> myisam engine is very fast for reading but innodb is better suited to >> lots of updates. > > My DB was set up as InnoDB from the outset :-D > >> 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. > > I looks like this is the best approach for sure, particularly now > you've got me thinking about recording other data in there too. > > > Thanks > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
