Rick, Last week we deployed new code, here at work, redesigning our application and session startup and management, specifically for improving our own click-through user/session tracking on our client's sites. Now, we're talking about a shared application templated system that services 1600+ sites (separate app for each site, same code base), but I can tell you that we have a single, dedicated MS SQL server/machine that is solely used for stats input, processing, and reporting. We have greatly improved (or, our DBA has) how we process this data, but it does chew up a ton of time and resources, with extreme care and attention being paid to indexes and table access locks. If you are maintaining a large, high traffic site, then I would definitely weigh your options carefully. Rolling your own stats can be very beneficial, especially if you need the ability to create specific information tracking (like clicking through steps in a Flash or Flex application), but if you don't require that sort of degree of specialized tracking then you may be much better off with balancing your application structure (page names, sub directory pathing, etc.) and using something that does log parsing (like WebTrends).
Cutter ________________ http://blog.cutterscrossing.com Rick Faircloth wrote: > Hi, all. > > Anyone know of a discussion/tutorial on the best way to go about > creating a website traffic management/reporting system? > > I've been using my own methods for several years, and, while they > work well enough, I know there are bound to be better methods. > > I'm looking not just for coding, but for overall discussion of > traffic management, such as archiving older data, tracking visitors > movement through a website. just about anything. > > Of course, I'm look for CF-based info. > > Rick > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
