Oh, I thought that SQLite wasn't that great on performance and that people wanted to replace/remove it from the core. "On of the most interesting things about FreeSWITCH to me has been the fact that most data in the system such as registrations are kept in a SQL database. The default installation uses SQLite internally though you can easily point FreeSWITCH at one of a number of other SQL servers such as PostgreSQL or MySQL via UnixODBC. Sadly, SQLite has become somewhat of a bottleneck in the core so future versions of FreeSWITCH will use less of it. For example, doing a "show channels" with over 500 channels in use starts to show issues. While I'm sad to see SQLite go in these cases, I am anxious to see how Minessale replaces it." http://www.anders.com/cms/275/FreeSWITCH/ClueCon/Anthony.Minessale I was just being curious about it :-) Regards, Diego On Fri, Mar 13, 2009 at 10:09 AM, Mathieu Rene <mrene_lists@avgs.ca> wrote:
In this case sqlite separates the core from what show channels uses etc, the DB is filled in by an event handler. This actually increases performance since you dont need to exclusively lock the session manager's table just to list channels.
Math
On 13-Mar-09, at 7:12 AM, Diego Viola wrote:
Erhm, this is what I wanted to say.
--
I think FreeSWITCH should leave that SQLite option as optional, I think it would be nicer if FS doesn't depend on any SQL at all, if you do a show channels right now with -nosql, this is what you will see:
freeswitch@internal> show channels -ERR SQL DISABLED NO CHANNEL DATA AVAILABLE!
freeswitch@internal>
I think it would be nice if FS can show you the information on real time, and on run time, without any SQL at all, and leave UnixODBC & SQLite as optional options, I also think this will improve performance.
On Fri, Mar 13, 2009 at 6:53 AM, Diego Viola <diego.viola@gmail.com> wrote:
This is what I get when I do a show channels with -nosql.
freeswitch@internal> show channels -ERR SQL DISABLED NO CHANNEL DATA AVAILABLE!
freeswitch@internal>
It would be nice if it prints the channels on runtime without the need/overheat of SQL.
Regards,
Diego
On Fri, Mar 13, 2009 at 6:46 AM, Diego Viola <diego.viola@gmail.com> wrote:
Hello,
I was wondering if it is possible to start FreeSWITCH without any SQL at all, yeah I know there is -nosql but I still want to have all the information available at run time, ie: show channels, sofia status, sofia status profile <profile>, everything.
Would that improve performance? I ask this because I heard that SQLite causes some performance issues and I heard it's being removed from the core, I also think that making that optional would be nice along with UnixODBC support for everything.
I also got a few situations where I had to rm -f /usr/local/freeswitch/db/* because there were some data there that was not supposed to be, that's why I think real time data on run time would be better.
Anyway, just some feedback/question I wanted to share, FS is awesome, keep up the great work.
Regards,
Diego
_______________________________________________ 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
_______________________________________________ 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