Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tabby
Starting Member
1 Post |
 Posted - 2008-05-28 : 21:57:54
|
| We have used web log files in the past. I have imported these into the SQL Server 2005 database and produced reports on numbers of unique visits and some journey type reporting. Now I am asked to have more up to date information. There are no clear requirements on what is to be reported. Just the general "we want to see more" type request. On the web site users log in and browse and purchase products. Traffic is expected to be high.Some ideas I have been thinking of:- Use counter table to keep track of number of visits to products. Will there be contention issues?- Use a separate logging database to log every action of interest as a separate row and create summary tables from there using scheduled jobs, say every hour.- Or something in-between, where there are a series of tables used to log specific information so that summary reports can be created more quickly. Are there are best practices around doing this type of thing?Any advice appreciated. Thanks. |
|
|
Zack
Starting Member
26 Posts |
Posted - 2008-06-02 : 14:58:36
|
| You might want to look into logging the web traffic to a database instead of having to import the log files. This would give you pretty much up to the minute reporting capabilities for the web site. The web site will need to be configured to log activity to the database instead of log file like it is currently doing. |
 |
|
|
|
|
|
Best practice for using DB for web site usage