3 ms·

Thanks for writing about this! This is a performance regression in the v0.8.0 release it seems, where the outer LIMIT clause doesn't correctly short-circuit ev

Thanks for writing about this! This is a performance regression in the v0.8.0 release it seems, where the outer LIMIT clause doesn't correctly short-circuit evaluation. Overall, for a `LIMIT 10` query, it should basically be instantaneous (and is, with v0.7.3). Will fix this asap. That said, DuckDB will *definitely* be much faster for processing Parquet files, that's for sure.

cube2222 4y ago
This is now fixed[0]. I've released a new version (v0.8.1) and now a query like this should once again take just ~tens of milliseconds to complete. [0]: https://github.com/cube2222/octosql/commit/ba4a8896be35ffdcc47c208faa86dbfff154c663 https://github.com/cube2222/octosql/commit/ba4a8896be35ffdcc...