I am currently working on a project where a lot of things will need to be logged, so the customer can have some reports. Basically, this will be a web site where each time a specific document appears in a search result, it will need to be logged. I will also need to log when when ever a link is clicked. Also, some publicity will appear on the site and I need to track how often each add was displayed.
For now, I am hesitating between two solutions: logging everything in the web site database and have an hourly agent that will move all log entries to the log database. option two is using OpenLog from OpenNTF. The biggest concern here is performance: is it better to write in the current database or writing in a different database is not a big performance hit.
This site will not get zillions of hits a day, but planning in case it does, do you have any related experience to relate? Any opinions on this matter?
As usual, all your help is greatly appreciated.