[Freeswitch-users] Start FreeSWITCH without any SQL but at the same time have all info available on realtime/runtime

[Diego Viola]

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 at 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 at internal> show channels
>> -ERR SQL DISABLED NO CHANNEL DATA AVAILABLE!
>>
>> freeswitch at 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 at gmail.com>
>> wrote:
>>> This is what I get when I do a show channels with -nosql.
>>>
>>> freeswitch at internal> show channels
>>> -ERR SQL DISABLED NO CHANNEL DATA AVAILABLE!
>>>
>>> freeswitch at 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 at 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 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
>
>
> _______________________________________________
> 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
>