4 ms·
How do virtual tables compare with regular tables for performance? I would assume SQLite has some optimisations for native tables (rather than reading the data
by justsomeuser 4y ago
How do virtual tables compare with regular tables for performance?
I would assume SQLite has some optimisations for native tables (rather than reading the data from another virtual table backed file)?
- lazypenguin 4y agoIt’s implementation dependent. You implement an interface and it’s up to the implementation to optimize the calls. The interface is also rather simplistic so there’s some optimization that can’t be done at the implementation level since SQLite didn’t provide all the information at the time of the query.