Comment Comment by aw3c2 The exact same query takes 60-70ms in SQLite for me. This is not a very good MapD advertisement...edit: Actually, I get this (uncached) in the sqlite3 CLI (the 60-70ms where via sqlitebrowser): Run Time: real 0.018 user 0.018164 sys 0.000135 Here is the database if you want to play around with it. https://transfer.sh/VkWXe/sqlite.db.gz parent aw3c2 8 years ago
edit: Actually, I get this (uncached) in the sqlite3 CLI (the 60-70ms where via sqlitebrowser):
Here is the database if you want to play around with it. https://transfer.sh/VkWXe/sqlite.db.gz