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