I'm new to Asterisk. How big can be sip.conf (and other: iax.conf, extensions.conf...) Is there point when I must use DB (MySQL...) instead of pure .conf?
Am Dienstag, 12. Oktober 2004 14:04 schrieb Goran Dj:> I'm new to Asterisk. > How big can be sip.conf (and other: iax.conf, extensions.conf...) > Is there point when I must use DB (MySQL...) instead of pure .conf? >There is no real answer to this question. Databases are always a good choice as the search strategies are substantially faster and the administration is much easier. If you only got few extensions don't use a database as it's not worth the work for the interfaces to setup. For example if a peer is searched in the conf file the average time will be N/2 to find the peer where N is the number of peers listed. Most databases should be able to search for this entry in log (N) time which for big N is far better than the above. Generally speaking a sip.conf can be as large as your ram but you certainly don't want to check that out. Jens
---------- Forwarded message ---------- From: Michael Bielicki <cypromis@gmail.com> Date: Tue, 12 Oct 2004 20:57:30 +0200 Subject: Re: [Asterisk-Users] How big .CONF files can be? To: Steven Critchfield <critch@basesys.com> machine tested last time was: 2 * XEON 2.4 GHz 2GB RAM RHAS 3.0 but that's some months ago when we gave up and moved to ast_data On Tue, 12 Oct 2004 13:55:11 -0500, Steven Critchfield <critch@basesys.com> wrote:> On Tue, 2004-10-12 at 20:33 +0200, Michael Bielicki wrote: > > 30.000 entries in iax.conf will kill * on startup > > Is that a defined problem, or is it a parser error, or is it a lack of > RAM in your machine to handle the data structures. > > 30k entries would add up to a pretty large amount of RAM. > -- > Steven Critchfield <critch@basesys.com> > >-- Michael Bielicki -- Michael Bielicki
The way the asterisk C code works is to look through a list of user/extensions/peers to find the search object. O = (N/2) After looking through the "Linked-List" of "users" and not finding it Asterisk then looks to the database using the mysql_user function call to find what it is looking for. It only takes the time needed to do a single select statement (i.e. the Database is faster if you have 1000's of .conf entries, slow if there are few to dozens to 100's.) In other words, if you move to a database don't keep things in the .conf file. But don't delete the .conf file as Asterisk still needs them to work. Race Vanderdecken Asterisk At Vanderdecken dot Com -----Original Message----- From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Goran Dj Sent: 12 October 2004 08:04 To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [Asterisk-Users] How big .CONF files can be? I'm new to Asterisk. How big can be sip.conf (and other: iax.conf, extensions.conf...) Is there point when I must use DB (MySQL...) instead of pure .conf? _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users