Re: how many page hits specified date range
From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 04/09/04
- Next message: Bob Barrows: "Re: 2nd try, left join"
- Previous message: Manohar Kamath [MVP]: "Re: how many page hits specified date range"
- In reply to: Garyrek: "Re: how many page hits specified date range"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 9 Apr 2004 12:19:46 -0400
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/ "Garyrek" <Garyrek@hotmail.com> wrote in message news:OgUgKvkHEHA.3820@tk2msftngp13.phx.gbl... > how do I analyze web server log files, any third party tool? > > Thanks > > "Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message > news:406d50db.47786553@msnews.microsoft.com... >> On Thu, 1 Apr 2004 16:06:47 -0800, "Garyrek" <Garyrek@hotmail.com> >> wrote: >> >> >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? >> >> >> Why not analyze the web server log files for thyis information >> instead? >> >> Jeff >> >> >"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message >> >news:u4Ixs$DGEHA.3984@TK2MSFTNGP10.phx.gbl... >> >> 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@hotmail.com> wrote in message >> >> news:%23NOm8yDGEHA.2436@TK2MSFTNGP09.phx.gbl... >> >> > 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@TAKETHISOUTkamath.com> wrote in > message >> >> > news:OJM9HSDGEHA.3080@tk2msftngp13.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 >> >a >> >> > time >> >> > > 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@hotmail.com> wrote in message >> >> > > news:OG28xLDGEHA.2876@TK2MSFTNGP09.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 >> >> > > >> >> > > >> >> > >> >> > >> >> >> >> >> > >> > >
- Next message: Bob Barrows: "Re: 2nd try, left join"
- Previous message: Manohar Kamath [MVP]: "Re: how many page hits specified date range"
- In reply to: Garyrek: "Re: how many page hits specified date range"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
