I need some ideas on my algortihm for a Hit Counter

Posted by stckvrflw on Stack Overflow See other posts from Stack Overflow or by stckvrflw
Published on 2010-03-26T08:47:05Z Indexed on 2010/03/26 8:53 UTC
Read the original article Hit count: 212

Filed under:

hitcounter

|

c#

|

sql-server-2000

|

tsql

|

sql

My algorithm is for a hit count, I am tring to not count for the same person twice if that person came to the site twice in a time internval (For example if he comes twice in 5 minutes, I want to count it as 1 for this person)

Here how my database looks like

UserIp     UserId          Date of user came
127.0.0.1   new.user.akb    26.03.2010 10:15:44
127.0.0.1   new.user.akb    26.03.2010 10:16:44
127.0.0.1   new.user.akb    26.03.2010 10:17:44
127.0.0.1   new.user.akb    26.03.2010 10:18:44
127.0.0.1   new.user.akb    26.03.2010 10:19:44
127.0.0.1   new.user.akb    26.03.2010 10:20:44
127.0.0.1   new.user.akb    26.03.2010 10:21:44
127.0.0.1   new.user.akb    26.03.2010 10:22:44
127.0.0.1   new.user.akb    26.03.2010 10:23:44

What I need to do is get number of distinct UserIPs from the table above that occured within a time interval. For example if I set the time interval for 5 minutes, and let say that is starts at

26.03.2010 10:15:44

Then I will get 2 as the results, since 1 distinct value between 10:15 to 10:20 and , 1 distinct value from 10:20 to 10:23,

For example if my interval is 3 minutes than the return result will be 3

Thanks.

© Stack Overflow or respective owner

Related posts about hitcounter

Dynamic rewrite rule - based on a hitcounter OR timestamp

as seen on Server Fault - Search for 'Server Fault'
Hi, Sorry for the lack of coherence with sys-admin stuff... I'm a programmer ;) I have the need to switch front-end's of a website based on either a hit-counter or some kind of timer (related question). Is this possible with mod_rewrite? any other interesting techniques? Thanks >>> More
Sharepoint hit counter is not displayed.

as seen on Stack Overflow - Search for 'Stack Overflow'
I followed the instructions here http://support.microsoft.com/kb/825532 After that when I preview my page, I can't see the hitcounter. I learned that it may be related to permissions of the site but I couldn't find how to do it. Is it realy related to permissions ? If so what should I do to ?… >>> More
Get page URL by using a program within a pageviewerwebpart in SharePoint

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a simple hit counter written in c# .net. I placed that counter to many pages using the pageviewerwebpart. What I want to do is, not only counting the hits, but also which page triggered the hit counter. So how can I retrieve the page URL with my hit counter ? Thanks. >>> More
I need some ideas on my algortihm for a Hit Counter

as seen on Stack Overflow - Search for 'Stack Overflow'
My algorithm is for a hit count, I am tring to not count for the same person twice if that person came to the site twice in a time internval (For example if he comes twice in 5 minutes, I want to count it as 1 for this person) Here how my database looks like UserIp UserId Date of user… >>> More
how to restrict a jsp hit counter?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing a hot counter in jsp, for my coursework. I have write the code, and there is not error and its working, but the problem is that: if the user have open the website and try to user different page, when ever that the user get back to the home page the counter still is adding a number , how… >>> More

Related posts about c#

.NET WebRequest.PreAuthenticate not quite what it sounds like

as seen on West-Wind - Search for 'West-Wind'
I’ve run into the problem a few times now: How to pre-authenticate .NET WebRequest calls doing an HTTP call to the server – essentially send authentication credentials on the very first request instead of waiting for a server challenge first? At first glance this sound like it should be easy:… >>> More
HttpWebRequest and Ignoring SSL Certificate Errors

as seen on West-Wind - Search for 'West-Wind'
Man I can't believe this. I'm still mucking around with OFX servers and it drives me absolutely crazy how some these servers are just so unbelievably misconfigured. I've recently hit three different 3 major brokerages which fail HTTP validation with bad or corrupt certificates at least according to… >>> More
The dynamic Type in C# Simplifies COM Member Access from Visual FoxPro

as seen on West-Wind - Search for 'West-Wind'
I’ve written quite a bit about Visual FoxPro interoperating with .NET in the past both for ASP.NET interacting with Visual FoxPro COM objects as well as Visual FoxPro calling into .NET code via COM Interop. COM Interop with Visual FoxPro has a number of problems but one of them at least got a lot… >>> More
Dynamic Type to do away with Reflection

as seen on West-Wind - Search for 'West-Wind'
The dynamic type in C# 4.0 is a welcome addition to the language. One thing I’ve been doing a lot with it is to remove explicit Reflection code that’s often necessary when you ‘dynamically’ need to walk and object hierarchy. In the past I’ve had a number of ReflectionUtils that used string based expressions… >>> More
Finding a Relative Path in .NET

as seen on West-Wind - Search for 'West-Wind'
Here’s a nice and simple path utility that I’ve needed in a number of applications: I need to find a relative path based on a base path. So if I’m working in a folder called c:\temp\templates\ and I want to find a relative path for c:\temp\templates\subdir\test.txt I want to receive back subdir\test… >>> More