[Freeswitch-users] SQLITE ALT

[Yiftach Golan]

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 at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121026/b6cd177b/attachment-0001.html