We've built an advert impression and clicks tracking system for a client and ever since we deployed it's absolutely killing our production web server.
My thoughts are that one page contains up to 5 adverts and if 10 users hit the site simultaneously that's 50 records (impressions) that need to be recorded at the same time.
Question: Would using Microsoft MSMQ to write these 'impression' records to disk every X amount of minutes improve the overall performance?
Thanks Jaques