RE: FN-FORUM Site traffic analysis running on SQL Server

date posted 28th January 2002 15:07

Hiya Andy

Just picking up on the ODBC logging point. I was talking to a far more
experienced web developer then I (not that hard really), and he suggested
that using IIS ODBC logging was a bad idea. Bascially he said that it's not
uncommon for the DB engine to fail while IIS is still serving pages, so
logging through ODBC will lose some visitor stats. This is certainly born
out by my experience of having Internet Seer running, fetching two pages
from a site, one static HTML and one with a DB call. The static HTML page
has a far higher uptime then the page with the DB call.

Norman