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

[Mathieu Rene]

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