res_config_sqlite3.conf 1.3 KB

12345678910111213141516171819202122232425262728293031
  1. ; Define a realtime database name to use in extconfig.conf
  2. ;
  3. ;[asterisk]
  4. ;dbfile => /var/lib/asterisk/realtime.sqlite3
  5. ;
  6. ; debug - Turn on debugging information
  7. ;debug=yes
  8. ;
  9. ; requirements - At startup, each realtime family will make requirements
  10. ; on the backend. There are several strategies for handling requirements:
  11. ; warn - Warn if the required column does not exist.
  12. ; createclose - Create columns as close to the requirements as possible.
  13. ; createchar - Create char columns only
  14. ;
  15. ;requirements=warn
  16. ;
  17. ; batch - SQLite 3 write performance can be greatly improved by wrapping
  18. ; multiple writes in transactions. This option specifies the duration in
  19. ; milliseconds of auto-generated transactions. Any changes made during an
  20. ; unfinished transaction will be immediately available to the same database
  21. ; connection, but any external connections could see a delay up to the value
  22. ; of this setting. It is also possible that if asterisk crashes, any changes
  23. ; made during this time could be lost. Due to the nearly 100x performance
  24. ; benefit, the default is 100 ms. Set to 0 to disable batching.
  25. ;
  26. ; PLEASE NOTE: If you need to write to the database from another connection
  27. ; you will need to set batch=0 as the transactions will cause the database
  28. ; to lock for writing.
  29. ;
  30. ;batch=1000