实现用户活动跟踪 [英] Implement User Activity Tracking

问题描述

我工作的一个ASP.NET网站与SQL Server 2008 R2。
我需要实现一个跟踪系统来追踪用户活动作为页面的用户浏览该项目喜欢等
我有很多的选择，并试图他们夫妇

1. 我试图发送一个带有插入每一页的用户浏览，但它
   原来，一个巨大的负荷在SQL Server上两天后我
   删除它


2. 我的溶液是缓冲的用户历史xml和数据库中的刷新他们每500个记录。这是工作不错，但它会很糟糕，当用户数量增加


3. 我发现有消息队列像MSMQ和SQL服务代理，但我没有在这个再往前走
   最后，我想听听您的意见和建议，以及您的MSMQ和SQL服务经纪人的意见，如果我应该去为他们和其中两个之一，为什么

解决方案

您可以尝试使用日志框架一样的 log4net的或 n日志这使您可以灵活地登录到不同的目标，也可以使用缓存/异步日志记录，以减少负载。

I am working on an ASP.NET website with sql server 2008 R2. i need to implement a tracking system to track user activity as which pages the user browsed which item liked and so on i have a lot of options and tried couple of them

1. i tried to send an insert with every page the user browses but it turned out a huge load on the sql server and after two days i removed it
2. I had a solution is to buffer the users history in xml and flush them every 500 records in the database. it is working fine but it would be bad when users number increase
3. I had found there is message queues like MSMQ and SQL Service Broker but i didnt go any further in this In the end i would like to hear your suggestions and recommendations as well as your comments for the MSMQ and SQL Service broker and if i should go for them and to which one of both and why

解决方案

You can try using a logging framework like log4net or nLog which gives you the flexibility to log to various targets and also use buffering / asynchronous logging to reduce the load.

这篇关于实现用户活动跟踪的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！