This is what I do currently with FreeSWITCH and postgresql and exceed 4000CPS on some pretty cheap hardware... Postgresql has some features to make this work really well across millions of prefixes... (consider 1 US ratedeck has approx 160K rows now... You¹re talking about 5million prefixes...) On 11/13/13 11:54 AM, "Andre" <andretodd@verizon.net> wrote:

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?

_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com

Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com

FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org

-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org G+ ClueCon : http://fs0.us/cluecon-gplus FB ClueCon : http://fs0.us/cluecon-fb G+ FreeSwitch : http://fs0.us/freeswitch-gplus FB FreeSWITCH : http://fs0.us/freeswitch-fb Twitter : @FreeSWITCH_WIRE irc.freenode.net #freeswitch