Hi Scott,<br>I can tell you that for us the sqlite3 was really bottleneck as well and in several times it just corrupted and we had to restart FreeSWITCH<br>However, it looks like everyone today is working with MySQL, for us MySQL is a much better choice because we are in a cloud environment and not in embedded environment <br>
A choice of the DB to use might be good <br><br>Thanks,<br>Yiftach.<br><br><div class="gmail_quote">On Thu, Oct 25, 2012 at 5:27 PM, S. Scott <span dir="ltr"><<a href="mailto:8f27e956@gmail.com" target="_blank">8f27e956@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Read somewhere about sqlite3 becoming a bottleneck point. This bottle<br>
necking, combined with the XML issues under discussion, I might<br>
suggest some investigation be given to DB2 EXPRESS-C (free community<br>
edition).<br>
<br>
DB2 is oft overlooked, but it is mature and capital-F FULL featured.<br>
It also supports trueXML, which allows native XML storage and<br>
retrieval via SQL language -- a nice fs get a long thing.<br>
<br>
it might be a great fit for high-end fs implementations. Left to<br>
default settings, it can be grabby of the machines resources -- cores<br>
and ram. Default likely too selfish for fs+db2 same-machine<br>
coexistence, but this is highly and easily tunable.<br>
<br>
In the small foot print (embedded) SQL engine space -- we love "mimer"<br>
<br>
Cheers,<br>
/S<br>
<br>
<br>
<br>
—————<br>
iThing: Big thumbs & little keys. Please excuse typo, spelling and<br>
grammar errors • Good planets are hard to find – think before you<br>
print • My desire to be well-informed is currently at odds with my<br>
desire to remain sane. • Last night I played a blank CD at full blast.<br>
The Mime next door went nuts.<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br>