Inserting data in background/async task what is the best way?

Question

I have an very quick/lightweight mvc action, that is requested very often and I need to maintain minimal response time under heavy load.

What i need to do, is from time to time depending on conditions to insert small amount of data to sql server (log unique id for statistics, for ~1-5% of queries).

I don't need inserted data for response and if I loose some of it because application restart or smth, I'll survive.

I imagine that I could queue somehow inserting and do it in background, may be even do some kind of buffering - like wait till queue collects 100 of inserts and then make them in one pass.

I'm pretty sure, that somebody must have done/seen such implementation before, there's no need to reinvent wheel, so if somebody could point to right direction, I would be thankful.

Answer 1

You could trigger a background task from your controller action that will do the insertion (fire and forget):

public ActionResult Insert(SomeViewModel model)
{
    Task.Factory.StartNew(() =>
    {
        // do the inserts
    });
    return View();
}

Be aware though that IIS could recycle the application at any time which would kill any running tasks.