[asterisk-bugs] [JIRA] (ASTERISK-27383) astdb: Document performance issues and alternatives

[Rijnhard Hessel (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-27383?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=254736#comment-254736 ] 

Rijnhard Hessel commented on ASTERISK-27383:
--------------------------------------------

not going to lie, it's pretty frustrating to have to manage multiple databases as performance bottlenecks, especially since ODBC is used in many other places. I would really have expected this to leverage ODBC aswell.
Very few applications (outside of the enterprise tech stacks) have any real reason to use multiple databases for their operations, and most end up compromising in some aspect and picking the database that's best suited for the primary use case.

I mean, it's not like you cant emulate key/value tables in any self-respecting RDBMS.

In general from a maintenance and support perspective (running a few hundred individual instances) asterisk has too many different components to manage, so axing sqllite and having all the data work through ODBC would go a long way to simplifying its management.

> astdb: Document performance issues and alternatives
> ---------------------------------------------------
>
>                 Key: ASTERISK-27383
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27383
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_db, Core/AstDB, Functions/func_db
>    Affects Versions: 13.18.0, GIT, 15.1.0
>            Reporter: Corey Farrell
>            Assignee: Unassigned
>
> All operations against astdb occur behind a global mutex.  This can lead to performance issues when astdb is used heavily by dialplan.
> * Add a warning to xmldoc for all astdb actions.
> * Best practice documents and examples?
> asterisk-dev discussion: http://lists.digium.com/pipermail/asterisk-dev/2017-October/076573.html



--
This message was sent by Atlassian JIRA
(v6.2#6252)