In this case, MySQL's INSERT DELAYED (http://dev.mysql.com/doc/refman/ 5.0/en/insert-delayed.html) might be a very good way of doing the tracking on your own server without slowing down page loads too much.
Of course one problem is that it's MySQL's own extension to SQL, so it will reduce your application's portability across different databases. And also, it only works with the MyISAM table type. Still, worth considering. -Jiri On Apr 12, 11:06 pm, "gwoo" <[EMAIL PROTECTED]> wrote: > Example: > Bakery tracks clicks on articles. > Option 1: > To get the article view page there are 20 queries performed. 1 of them > is an update on the number of views and only happens when the Session > has not been set. A javascript link to an analytics app. (cause it > provides much more information about the visitor) > Option 2: > 19 queries and a javascript link to an analytics app > > Now, I want to display most popluar posts > Option 1: > $this->Article->findAll(null, null, 'Article.views DESC'); > Option 2: > query analytics webservice > > I agree that trying to track all clicks and information on them is > pointless and the need for analytics is important. But I think its > also clear that when you want to provide your users with information > regarding the actions of other users, you are better off tracking it > on your own. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
