...also tried using RhoUtils.load_offline_data but my table is not found. I assume that the table would need to be created in the 'system' database rather than the user accessible database. So that did not work for me.
transaction requires that the data model is loaded.
Do you've something like (assuming that the model name is "ItemData"):
This at the top of the controller file, together with the usual require line:
this in your controller action code (the one you posted there)
db = ::Rho::RHO.get_src_db('ItemData')
You asked about previous experiences. I've seen MC9190 inserting more than 2000 records in around 5 seconds (400 record/s).
Hopes this helps
Yes, I have require_source too at the start of my test function.
I have used sqlite before in other application scenarios on other mobile devices and reached insert speeds as you suggest. I cannot understand why I'm getting such a slow processing speed.
This is odd.
As you stated, I had a code error in the line...
db = ::Rho::RHO.get_src_db(@ItemData)
...@ItemData was not initialised! Schoolboy error! Now changed to 'ItemData' and now runs perfectly.
I was checking the result (db) and it looked ok to me returning a ref, but obviously it wasn't actually ok.