SQLilte query much slower through RSqlite than sqlite3 command-line interface
SQLilte query much slower through RSqlite than sqlite3 command-line interface sqlite
sqlite
What matters is the version of RSQLite you have. Your version of R seems to be over a year old so if your RSQLite is just as old it could be a much older engine (eg, 3.6.4) as suggested by Benoit.