I´ve used Sqlite-Sync project, which really simplifies access to Sqlite.
But I have the problem already addressed as "CAN NOT ENLARGE MEMORY ARRAYS" posts.
I´ve increased TOTAL_MEMORY to 512 MB. With this, the running system time increased from 1 minute to 10 minutes before giving the error.
I wouldn´t like to further increase TOTAL_MEMORY beyond 512 MB.
My system uses basically Javascript by reading about 5 tables in Sqlite. It compares, updates or inserts data automatically at new Modbus reading (Modbus-Serial).
I´ve used Sqlite-Sync project, which really simplifies access to Sqlite.
But I have the problem already addressed as "CAN NOT ENLARGE MEMORY ARRAYS" posts.
I´ve increased TOTAL_MEMORY to 512 MB. With this, the running system time increased from 1 minute to 10 minutes before giving the error.
I wouldn´t like to further increase TOTAL_MEMORY beyond 512 MB.
My system uses basically Javascript by reading about 5 tables in Sqlite. It compares, updates or inserts data automatically at new Modbus reading (Modbus-Serial).