<HTML>
<HEAD>
<TITLE>Re: [Freeswitch-users] Dialer Switch with LCR Database</TITLE>
</HEAD>
<BODY>
<FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>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...)<BR>
<BR>
<BR>
On 11/13/13 11:54 AM, "Andre" <<a href="andretodd@verizon.net">andretodd@verizon.net</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT COLOR="#1F497D"><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'>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.<BR>
<BR>
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.<BR>
<BR>
My query is a stored procedure and takes about 1 to 2 milliseconds to run.<BR>
<BR>
I know SQL Server 2014 will have in memory tables and I do plan on using it.<BR>
<BR>
What are others thoughts for a high capacity dialer FreeSWITCH switch?<BR>
</SPAN></FONT></FONT><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'><BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_________________________________________________________________________<BR>
Professional FreeSWITCH Consulting Services:<BR>
<a href="consulting@freeswitch.org">consulting@freeswitch.org</a><BR>
<a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
<BR>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
<a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
<BR>
Official FreeSWITCH Sites<BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
<a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
<BR>
FreeSWITCH-users mailing list<BR>
<a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'><BR>
</SPAN></FONT></FONT><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>-- <BR>
Ken<BR>
<a href="http://www.FreeSWITCH.org">http://www.FreeSWITCH.org</a><BR>
<a href="http://www.ClueCon.com">http://www.ClueCon.com</a><BR>
<a href="http://www.OSTAG.org">http://www.OSTAG.org</a><BR>
G+ ClueCon : <a href="http://fs0.us/cluecon-gplus">http://fs0.us/cluecon-gplus</a><BR>
FB ClueCon : <a href="http://fs0.us/cluecon-fb">http://fs0.us/cluecon-fb</a><BR>
G+ FreeSwitch : <a href="http://fs0.us/freeswitch-gplus">http://fs0.us/freeswitch-gplus</a><BR>
FB FreeSWITCH : <a href="http://fs0.us/freeswitch-fb">http://fs0.us/freeswitch-fb</a> <BR>
Twitter : @FreeSWITCH_WIRE<BR>
irc.freenode.net #freeswitch<BR>
</SPAN></FONT>
</BODY>
</HTML>