Hi Scott, 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 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 A choice of the DB to use might be good Thanks, Yiftach. On Thu, Oct 25, 2012 at 5:27 PM, S. Scott <8f27e956@gmail.com> wrote:
Read somewhere about sqlite3 becoming a bottleneck point. This bottle necking, combined with the XML issues under discussion, I might suggest some investigation be given to DB2 EXPRESS-C (free community edition).
DB2 is oft overlooked, but it is mature and capital-F FULL featured. It also supports trueXML, which allows native XML storage and retrieval via SQL language -- a nice fs get a long thing.
it might be a great fit for high-end fs implementations. Left to default settings, it can be grabby of the machines resources -- cores and ram. Default likely too selfish for fs+db2 same-machine coexistence, but this is highly and easily tunable.
In the small foot print (embedded) SQL engine space -- we love "mimer"
Cheers, /S
————— iThing: Big thumbs & little keys. Please excuse typo, spelling and grammar errors • Good planets are hard to find – think before you print • My desire to be well-informed is currently at odds with my desire to remain sane. • Last night I played a blank CD at full blast. The Mime next door went nuts.
_________________________________________________________________________ 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