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