Re: Generating "most popular article" lists without crushing the serve

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks, John. I've identified one another option: as of version 8, SurfStats
(a traffic analysis program) will export reports in Excel format, which I
could presumably interrogate with my ASP.NET app. We bought a license for
SurfStats, so this may be a good choice for me.

Microsoft should sell a good analysis program, or bundle it with IIS. It
seems like a basic need for people who may run sites.

-KF


"John Timney (MVP)" <x_john@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:T9WdnebZtPEblDfYRVnyhgA@xxxxxxxxxxxxxxxxx
Not happy with any of the prebuilt solutions that I can afford.

...and therein lies the problem. Its a complex subject, and experience
around these areas tends to be expensive as its more niche than mainstream
forms development for example, which is why your struggling to find an all
seeing class. Unfortunately there many ways to crack the same nut and the
pre-built nutcrackers that seem to work are not cheap for all of those
reasons. Whatever solution you turn to - make sure the solution itself
doesn't degrade your web servers performance.

--
--
Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com
http://www.johntimney.com/blog


<kenfine@xxxxxxxxxxxxx> wrote in message
news:eqBlec6NHHA.780@xxxxxxxxxxxxxxxxxxxxxxx
Thank you. Here is an article that discusses the tactic you describe:
http://www.superdotnet.com/Article.aspx?ArticleID=122

They're hooking Application_BeginRequest in global.asax rather than
Application_PreRequestHandlerExecute as you suggested; I wonder if
there's a material difference.

I'm a little surprised nobody has written an all-knowing, all-seeing
class and stored procedure set for addressing site statistic issues. For
my needs, I'm finding after-the-fact log analysis less appealing than the
idea of a SQL database I could interrogate.

Some other options: "Log Parser" allows SQL-type queries against any most
any windows log.
http://www.asp.net/sandbox/app_logparser.aspx
I'm a little disappointed the package doesn't have much in the way of
instructions or example for how to get up and running working with IIS.
In theory, this could be a great solution for my needs.

I'm also surprised that many of the stats packages don't seem to expose
their report data in any sort of structured form, say, in XML. You're
stuck either "rolling your own" solution and coding everything, or
working with packages that seem more directed at Desktop users. Not happy
with any of the prebuilt solutions that I can afford.

-KF


"Peter Bromberg [C# MVP]" <pbromberg@xxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:1B0D04D2-65DA-4546-B778-DE62CBC5D1BC@xxxxxxxxxxxxxxxx
As an alternative to John's recommendation, you could try hooking the
Application_PreRequestHandlerExecute event in either global.asax or in
an
HttpModule that handles the event. You can thus interrogate the request
just
before it gets passed to the page processor, and log all the data you
want
into your Sql Server.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net




"kenfine@xxxxxxxxxxxxx" wrote:

The New York Times and many other online publications automatically
generate
"most popular article" lists that cover, say, the last 24 hours.

I am looking for guidance and/or code on the best way to do this in
ASP.NET
2 in a way that

a) won't crush the server
and
b) won't be surpressed by any of ASP.NET's caching options: you want
the
"hits" to still be registered even if someone is clicking through to a
cached instance of the page.

What are the common solutions for dealing with this? Is it common to
use a
stats package and operate on the data store that's generated by the
package,
or is this overkill for this intended purpose?

SQL Server is available, and I have full control of the server.

-KF









.

Relevant Pages

  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: sunmanagers Digest, Vol 34, Issue 14
    ... Christopher sent me a link to ftp.cs.tu-berlin.de that has all patches sun ... Subject: SUMMARY: Setting up mail on a Solaris Server ... however I seem to be having issues finding a binary package. ... Problems while installing 108528-29 for Sol8 machine ...
    (SunManagers)
  • Re: DTS Environment Control
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... When run from the production environment, the production server is accessed and when run from the test environment, the test server is accessed. ... For simple packages it's not too big of deal - but for more complete ones - you can spend an hour carefully changing all your connections. ... I had one solution where we would add an ActiveX script task as the very first step, that would determine what SERVER the package was executing from - and based on that would dynamically change all the connections by looking up the package name and server from a DB. ...
    (microsoft.public.sqlserver.dts)
  • is yum working? unable to update a system
    ... # yum update ... Server: Dag RPM Repository for Fedora Core ... .Package mplayer-mencoder needs libxvidcore.so.2, this is not ...
    (Fedora)