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.
just use odbc or the native pgsql extensions if you need more performance the sqlite k On Oct 26, 2012 11:03 AM, "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
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
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@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@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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
Here is a nice comparison : http://zenadmin.org/en/blog/post720.html On Fri, Oct 26, 2012 at 3:28 PM, Anthony Minessale < anthony.minessale@gmail.com> wrote:
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@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@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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
_________________________________________________________________________ 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
Around the time that was written a fairly nasty bug related to performance of SQLite and some linux kernel versions. I can't for the life of me find that story... I would get in and test drive it yourself before proclaiming one thing is better than the other. Wish I could find that link... it was rather in depth. On Oct 26, 2012, at 6:06 PM, Yiftach Golan wrote:
Here is a nice comparison : http://zenadmin.org/en/blog/post720.html
-- Brian West brian@freeswitch.org FreeSWITCH Solutions, LLC PO BOX PO BOX 2531 Brookfield, WI 53008-2531 Twitter: @FreeSWITCH_Wire http://freeswitchcookbook.com http://freeswitchbook.com T: +1.213.286.0410 | F: +1.213.286.0401 | M: +1.918.424.WEST iNUM: +883 5100 1286 0410
participants (5)
-
Anthony Minessale
-
Brian West
-
Ken Rice
-
S. Scott
-
Yiftach Golan