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

_________________________________________________________________________
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