I’m currently entering rows one-at-a time using Stmt,bind!,execute! and the process is quite slow, even though there are only 3 columns in the table, and I have a lot of rows to insert.
I’ve been looking through the docs and I haven’t found a way to generate a more efficient formulation within Julia (*). it looks as though the queries have to be performed one-at-a-time. is there a way to prepare a block of inserts ?
(*) the most efficient formulation i’ve found so far is to generate a csv file and use csv import in sqlite.