I need to drop a table and recreate it, after which I need to insert 30k records.
Sometimes dropping works - but then does not recreate the table.
Nothing in database. Database complains - 'database is locked'.
When I recreate the table directly on cli, it works.
The 30k records should be a begin/commit transaction (?) for speed?
Currently I use a template node and prepare all statements and put that in
msg.topic and set the sqlite node to batch without response. But whatever step I take separately it does not appear to function properly.
Is there a "best approach" tactic for working with sqlite because I am losing my patience with the inconsistent behaviour because I don't understand what is happening.