[sr-dev] changing behavior in db_text

[Luis Azedo]

Hi All,


db_text modules manages the tables data in shm_mem

db_text module uses pkg_mem to store query results which leads to some problems.


when we have large text files with a lot of rows (location, active_watchers, presentity), the startup procedure fetches all the records, which makes db_text copy all records from shm_mem to pkg_mem, leading to memory failures.


i now have a patch that changes this behaviour.

it creates temp tables in shm_mem with the results

if implements fetch_result so that startup procedures that fetch all rows can safely run without memory issues.


if anyone has anything against, please reply.

i would like to get this merged before 5.0


Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20170105/07b79be7/attachment.html>