how many page hits specified date range

**Manohar Kamath [MVP]** · Jul 19 '05, 11:47 AM

Re: how many page hits specified date range

Are you not storing this in a database? That would be the ideal solution --
just implement a simple function that logs hits to a page, along with a time
stamp. It is also very flexible to report on whatever other parameters you
want to report on.

--
Manohar Kamath
Editor, .netWire

https://www.dotnetwire.com

"Garyrek" <Garyrek@hotmai l.com> wrote in message
news:OG28xLDGEH A.2876@TK2MSFTN GP09.phx.gbl...
Hi

I have a requirement where I need to make a report for each auto dealer how
many hits they got on specified date range, so for each car detail page I
increment the counter and total it while doing that I store the last hit
date, this gives the total hits for the dealer BUT does not facilitate date
range

How do I give the user a date range so that he can check how many hits the
dealer got lets say for last week OR last couple of days?

Thanks much!

Gary

**Garyrek** · Jul 19 '05, 11:47 AM

Re: how many page hits specified date range

this? I store hits counter, firsthit and lasthit in the database having this
I could only show all the hits since creation to last hit but NOT for last
one week or couple of days....
"Manohar Kamath [MVP]" <mkamath@TAKETH ISOUTkamath.com > wrote in message
news:OJM9HSDGEH A.3080@tk2msftn gp13.phx.gbl...[color=blue]
> Are you not storing this in a database? That would be the ideal[/color]
solution --[color=blue]
> just implement a simple function that logs hits to a page, along with a[/color]
time[color=blue]
> stamp. It is also very flexible to report on whatever other parameters you
> want to report on.
>
> --
> Manohar Kamath
> Editor, .netWire
> www.dotnetwire.com
>
>
> "Garyrek" <Garyrek@hotmai l.com> wrote in message
> news:OG28xLDGEH A.2876@TK2MSFTN GP09.phx.gbl...
> Hi
>
> I have a requirement where I need to make a report for each auto dealer[/color]
how[color=blue]
> many hits they got on specified date range, so for each car detail page I
> increment the counter and total it while doing that I store the last hit
> date, this gives the total hits for the dealer BUT does not facilitate[/color]
date[color=blue]
> range
>
> How do I give the user a date range so that he can check how many hits the
> dealer got lets say for last week OR last couple of days?
>
> Thanks much!
>
> Gary
>
>[/color]

**Aaron Bertrand [MVP]** · Jul 19 '05, 11:47 AM

Re: how many page hits specified date range

Then change what you're storing. The database can't magically extrapolate
data you've already compressed.

--
Aaron Bertrand
SQL Server MVP

http://www.aspfaq.com/

"Garyrek" <Garyrek@hotmai l.com> wrote in message
news:%23NOm8yDG EHA.2436@TK2MSF TNGP09.phx.gbl. ..[color=blue]
> this? I store hits counter, firsthit and lasthit in the database having
> this
> I could only show all the hits since creation to last hit but NOT for last
> one week or couple of days....[/color]

**Manohar Kamath [MVP]** · Jul 19 '05, 11:47 AM

Re: how many page hits specified date range

Store individual hits, with timestamp, that way you are more data that you
can report on -- weekly, hourly, or even minutely :)

Link Hit Time
---------- -----
1 1 4/1/2004 1:12:23 AM
1 2 4/1/2004 1:12:24 AM
2 3 4/1/2004 1:12:25 AM

Collecting more data can only help you.

--
Manohar Kamath
Editor, .netWire

https://www.dotnetwire.com

"Garyrek" <Garyrek@hotmai l.com> wrote in message
news:%23NOm8yDG EHA.2436@TK2MSF TNGP09.phx.gbl. ..[color=blue]
> this? I store hits counter, firsthit and lasthit in the database having[/color]
this[color=blue]
> I could only show all the hits since creation to last hit but NOT for last
> one week or couple of days....
> "Manohar Kamath [MVP]" <mkamath@TAKETH ISOUTkamath.com > wrote in message
> news:OJM9HSDGEH A.3080@tk2msftn gp13.phx.gbl...[color=green]
> > Are you not storing this in a database? That would be the ideal[/color]
> solution --[color=green]
> > just implement a simple function that logs hits to a page, along with a[/color]
> time[color=green]
> > stamp. It is also very flexible to report on whatever other parameters[/color][/color]
you[color=blue][color=green]
> > want to report on.
> >
> > --
> > Manohar Kamath
> > Editor, .netWire
> > www.dotnetwire.com
> >
> >
> > "Garyrek" <Garyrek@hotmai l.com> wrote in message
> > news:OG28xLDGEH A.2876@TK2MSFTN GP09.phx.gbl...
> > Hi
> >
> > I have a requirement where I need to make a report for each auto dealer[/color]
> how[color=green]
> > many hits they got on specified date range, so for each car detail page[/color][/color]
I[color=blue][color=green]
> > increment the counter and total it while doing that I store the last hit
> > date, this gives the total hits for the dealer BUT does not facilitate[/color]
> date[color=green]
> > range
> >
> > How do I give the user a date range so that he can check how many hits[/color][/color]
the[color=blue][color=green]
> > dealer got lets say for last week OR last couple of days?
> >
> > Thanks much!
> >
> > Gary
> >
> >[/color]
>
>[/color]

**Garyrek** · Jul 19 '05, 11:47 AM

Re: how many page hits specified date range

Hi Manohar / Aaron
I should have mentioned this earlier, this way the table gets too big
henceforth database, is there any other way like storing in a file or using
pagecounter component?

thanks

Girish

"Manohar Kamath [MVP]" <mkamath@TAKETH ISOUTkamath.com > wrote in message
news:u4Ixs$DGEH A.3984@TK2MSFTN GP10.phx.gbl...[color=blue]
> Store individual hits, with timestamp, that way you are more data that you
> can report on -- weekly, hourly, or even minutely :)
>
> Link Hit Time
> ---------- -----
> 1 1 4/1/2004 1:12:23 AM
> 1 2 4/1/2004 1:12:24 AM
> 2 3 4/1/2004 1:12:25 AM
>
> Collecting more data can only help you.
>
> --
> Manohar Kamath
> Editor, .netWire
> www.dotnetwire.com
>
>
> "Garyrek" <Garyrek@hotmai l.com> wrote in message
> news:%23NOm8yDG EHA.2436@TK2MSF TNGP09.phx.gbl. ..[color=green]
> > this? I store hits counter, firsthit and lasthit in the database having[/color]
> this[color=green]
> > I could only show all the hits since creation to last hit but NOT for[/color][/color]
last[color=blue][color=green]
> > one week or couple of days....
> > "Manohar Kamath [MVP]" <mkamath@TAKETH ISOUTkamath.com > wrote in message
> > news:OJM9HSDGEH A.3080@tk2msftn gp13.phx.gbl...[color=darkred]
> > > Are you not storing this in a database? That would be the ideal[/color]
> > solution --[color=darkred]
> > > just implement a simple function that logs hits to a page, along with[/color][/color][/color]
a[color=blue][color=green]
> > time[color=darkred]
> > > stamp. It is also very flexible to report on whatever other parameters[/color][/color]
> you[color=green][color=darkred]
> > > want to report on.
> > >
> > > --
> > > Manohar Kamath
> > > Editor, .netWire
> > > www.dotnetwire.com
> > >
> > >
> > > "Garyrek" <Garyrek@hotmai l.com> wrote in message
> > > news:OG28xLDGEH A.2876@TK2MSFTN GP09.phx.gbl...
> > > Hi
> > >
> > > I have a requirement where I need to make a report for each auto[/color][/color][/color]
dealer[color=blue][color=green]
> > how[color=darkred]
> > > many hits they got on specified date range, so for each car detail[/color][/color][/color]
page[color=blue]
> I[color=green][color=darkred]
> > > increment the counter and total it while doing that I store the last[/color][/color][/color]
hit[color=blue][color=green][color=darkred]
> > > date, this gives the total hits for the dealer BUT does not facilitate[/color]
> > date[color=darkred]
> > > range
> > >
> > > How do I give the user a date range so that he can check how many hits[/color][/color]
> the[color=green][color=darkred]
> > > dealer got lets say for last week OR last couple of days?
> > >
> > > Thanks much!
> > >
> > > Gary
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

**Aaron Bertrand [MVP]** · Jul 19 '05, 11:47 AM

Re: how many page hits specified date range

You could have a background process summarize the rows each day into daily /
weekly buckets, and then delete out of the heavy usage table. That way the
table does not go out of control, it has at most a week of data at any one
time.

--
Aaron Bertrand
SQL Server MVP

http://www.aspfaq.com/

"Garyrek" <Garyrek@hotmai l.com> wrote in message
news:O$vvmZEGEH A.2436@TK2MSFTN GP09.phx.gbl...[color=blue]
> Hi Manohar / Aaron
> I should have mentioned this earlier, this way the table gets too big
> henceforth database, is there any other way like storing in a file or
> using
> pagecounter component?
>
> thanks
>
> Girish
>
> "Manohar Kamath [MVP]" <mkamath@TAKETH ISOUTkamath.com > wrote in message
> news:u4Ixs$DGEH A.3984@TK2MSFTN GP10.phx.gbl...[color=green]
>> Store individual hits, with timestamp, that way you are more data that
>> you
>> can report on -- weekly, hourly, or even minutely :)
>>
>> Link Hit Time
>> ---------- -----
>> 1 1 4/1/2004 1:12:23 AM
>> 1 2 4/1/2004 1:12:24 AM
>> 2 3 4/1/2004 1:12:25 AM
>>
>> Collecting more data can only help you.
>>
>> --
>> Manohar Kamath
>> Editor, .netWire
>> www.dotnetwire.com
>>
>>
>> "Garyrek" <Garyrek@hotmai l.com> wrote in message
>> news:%23NOm8yDG EHA.2436@TK2MSF TNGP09.phx.gbl. ..[color=darkred]
>> > this? I store hits counter, firsthit and lasthit in the database having[/color]
>> this[color=darkred]
>> > I could only show all the hits since creation to last hit but NOT for[/color][/color]
> last[color=green][color=darkred]
>> > one week or couple of days....
>> > "Manohar Kamath [MVP]" <mkamath@TAKETH ISOUTkamath.com > wrote in message
>> > news:OJM9HSDGEH A.3080@tk2msftn gp13.phx.gbl...
>> > > Are you not storing this in a database? That would be the ideal
>> > solution --
>> > > just implement a simple function that logs hits to a page, along with[/color][/color]
> a[color=green][color=darkred]
>> > time
>> > > stamp. It is also very flexible to report on whatever other
>> > > parameters[/color]
>> you[color=darkred]
>> > > want to report on.
>> > >
>> > > --
>> > > Manohar Kamath
>> > > Editor, .netWire
>> > > www.dotnetwire.com
>> > >
>> > >
>> > > "Garyrek" <Garyrek@hotmai l.com> wrote in message
>> > > news:OG28xLDGEH A.2876@TK2MSFTN GP09.phx.gbl...
>> > > Hi
>> > >
>> > > I have a requirement where I need to make a report for each auto[/color][/color]
> dealer[color=green][color=darkred]
>> > how
>> > > many hits they got on specified date range, so for each car detail[/color][/color]
> page[color=green]
>> I[color=darkred]
>> > > increment the counter and total it while doing that I store the last[/color][/color]
> hit[color=green][color=darkred]
>> > > date, this gives the total hits for the dealer BUT does not
>> > > facilitate
>> > date
>> > > range
>> > >
>> > > How do I give the user a date range so that he can check how many
>> > > hits[/color]
>> the[color=darkred]
>> > > dealer got lets say for last week OR last couple of days?
>> > >
>> > > Thanks much!
>> > >
>> > > Gary
>> > >
>> > >
>> >
>> >[/color]
>>
>>[/color]
>
>[/color]

**Jeff Cochran** · Jul 19 '05, 11:48 AM

Re: how many page hits specified date range

On Thu, 1 Apr 2004 16:06:47 -0800, "Garyrek" <Garyrek@hotmai l.com>
wrote:
[color=blue]
>Hi Manohar / Aaron
>I should have mentioned this earlier, this way the table gets too big
>henceforth database, is there any other way like storing in a file or using
>pagecounter component?[/color]

Why not analyze the web server log files for thyis information
instead?

Jeff
[color=blue]
>"Manohar Kamath [MVP]" <mkamath@TAKETH ISOUTkamath.com > wrote in message
>news:u4Ixs$DGE HA.3984@TK2MSFT NGP10.phx.gbl.. .[color=green]
>> Store individual hits, with timestamp, that way you are more data that you
>> can report on -- weekly, hourly, or even minutely :)
>>
>> Link Hit Time
>> ---------- -----
>> 1 1 4/1/2004 1:12:23 AM
>> 1 2 4/1/2004 1:12:24 AM
>> 2 3 4/1/2004 1:12:25 AM
>>
>> Collecting more data can only help you.
>>
>> --
>> Manohar Kamath
>> Editor, .netWire
>> www.dotnetwire.com
>>
>>
>> "Garyrek" <Garyrek@hotmai l.com> wrote in message
>> news:%23NOm8yDG EHA.2436@TK2MSF TNGP09.phx.gbl. ..[color=darkred]
>> > this? I store hits counter, firsthit and lasthit in the database having[/color]
>> this[color=darkred]
>> > I could only show all the hits since creation to last hit but NOT for[/color][/color]
>last[color=green][color=darkred]
>> > one week or couple of days....
>> > "Manohar Kamath [MVP]" <mkamath@TAKETH ISOUTkamath.com > wrote in message
>> > news:OJM9HSDGEH A.3080@tk2msftn gp13.phx.gbl...
>> > > Are you not storing this in a database? That would be the ideal
>> > solution --
>> > > just implement a simple function that logs hits to a page, along with[/color][/color]
>a[color=green][color=darkred]
>> > time
>> > > stamp. It is also very flexible to report on whatever other parameters[/color]
>> you[color=darkred]
>> > > want to report on.
>> > >
>> > > --
>> > > Manohar Kamath
>> > > Editor, .netWire
>> > > www.dotnetwire.com
>> > >
>> > >
>> > > "Garyrek" <Garyrek@hotmai l.com> wrote in message
>> > > news:OG28xLDGEH A.2876@TK2MSFTN GP09.phx.gbl...
>> > > Hi
>> > >
>> > > I have a requirement where I need to make a report for each auto[/color][/color]
>dealer[color=green][color=darkred]
>> > how
>> > > many hits they got on specified date range, so for each car detail[/color][/color]
>page[color=green]
>> I[color=darkred]
>> > > increment the counter and total it while doing that I store the last[/color][/color]
>hit[color=green][color=darkred]
>> > > date, this gives the total hits for the dealer BUT does not facilitate
>> > date
>> > > range
>> > >
>> > > How do I give the user a date range so that he can check how many hits[/color]
>> the[color=darkred]
>> > > dealer got lets say for last week OR last couple of days?
>> > >
>> > > Thanks much!
>> > >
>> > > Gary
>> > >
>> > >
>> >
>> >[/color]
>>
>>[/color]
>[/color]

how many page hits specified date range

how many page hits specified date range

Comment

Comment

Comment

Comment

Comment

Comment

Comment