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
If you are seeking high performance and max throughput you should not use MSMQ. In your case I would ask if you actually need real time tracking.
If you want your tracking to have minimum impact on your web frontend you should go for dumping the tracking data into normal web server logfiles by means of pixel tracking and use a backend process to load these logfiles into your tracking analysis system.
From what I understand from your question, the problem is that every single ad impression writes it's own tracking record which of course will degrade the web frontend performance.