[Freeswitch-users] SQLITE ALT

[Anthony Minessale]

We try not to talk about performance because its misleading.
It all depends on your platform , the hardware and the configuration you
choose.



On Fri, Oct 26, 2012 at 12:35 PM, Yiftach Golan <yiftah at choochee.com> wrote:

> 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
>>
>
>
> _________________________________________________________________________
> 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
>
>


-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121026/ac87fbe9/attachment-0001.html