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 -~----------~----~----~----~------~----~------~--~---
