My theory about that would be that it would only slow the process of getting a slow application down.
I would try to make the statistics application fast as hell, we have the stats for all our customers in one table (actually two, one for ip2country data), and so far it has just been a question of how to build a smart query that will be fast enough. The slowest up until now are the user-agent queries (because of a stupidity on my side) you should also create a separate table for user agents and possibly for OS's as well if you want to get those details. On the log-side, like Auke says there is no slowdown whatsoever if you insert a record on every request. The server we have this running on is no myspace by any means though, it's just generating about 4000 hits a day so you might have different results. otoh, you might just be better of using webtrends or the likes, I went this route because I wanted to see if CF was up to it, and I like to have control over stuff ;). Mingo. blists wrote: > This system is for "members/users" of our webapp. What if, for each user > that used this service (its and add-on), we created a new table on the fly. > That way each table would be used for that users tracking only and not for > all the users. Is that a viable idea? > > BrookD > > > At 03:41 PM 6/13/2006, you wrote: > >>> If you do not need to keep track of IP addresses and dates, I would go this >>> route. If not, then make sure you have your columns as small as possible >>> and maybe purge the info on a regular basis. >>> >> If you do need that info you do best to have a table like Jabob proposes >> anyway. Any inserts into a table you yourself proposed doesn't really do >> any harm to processing. If you need to do a query that counts the number >> of hits on that table, that will probably slow down as the table grows. So >> you can do the count (to determine what to show) on 'Jacobs' table' and >> have the other info in a separate table. OR just analyze your webserver >> logfiles for that info later on :-) >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244399 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
