3 ms·
this is really cool! Would you mind if I ask about "performance"? I'm working on a toy project with luajit and I can either use ffi and SQLite C API (which can
by _benj 5y ago
this is really cool! Would you mind if I ask about "performance"? I'm working on a toy project with luajit and I can either use ffi and SQLite C API (which can be a little complicated) or just use the CLI and capture the output of a command as a string and parse that.
As I'm writing this I'm thinking that I should just run o=some tests using both approaches, but, how's the performance for you? Any noticeable delays or something of the sort?
- chmaynard 5y agoMy guess is that the query itself takes the same amount of time either way, C API or CLI. There may be some I/O overhead when using sqlite3, but I doubt if it's anything to worry about. The beauty of using sqlite3 is that it hides the complexity of the C API, which is procedural.