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