I’m building a dialer deck that using a custom LCR. I look up LERG and LNR in my database and I look at 30 + rate decks to find the LCR.

I want to know is it realistic to be doing the LCR in a database? I expect 1000 to 2000 CPS so that means I hit the database that many times per second.

My query is a stored procedure and takes about 1 to 2  milliseconds to run.

I know SQL Server 2014 will have in memory tables and I do plan on using it.

What are others thoughts for a high capacity dialer FreeSWITCH switch?