Skip to content

Improve SQLite LIKE performance#1209

Merged
mvorisek merged 5 commits intodevelopfrom
improve_sqlite_like_lazy_eval
May 6, 2024
Merged

Improve SQLite LIKE performance#1209
mvorisek merged 5 commits intodevelopfrom
improve_sqlite_like_lazy_eval

Conversation

@mvorisek
Copy link
Copy Markdown
Member

@mvorisek mvorisek commented May 6, 2024

Based on https://sqlite.org/forum/info/00f60e440cb23c99 discussion.

The performance for 1M rows went from 8_000 ms to 250 ms.

@mvorisek mvorisek changed the title Improve SQLite LIKE lazy eval Improve SQLite LIKE performance May 6, 2024
@mvorisek mvorisek marked this pull request as ready for review May 6, 2024 16:45
@mvorisek mvorisek merged commit 0fdeaed into develop May 6, 2024
@mvorisek mvorisek deleted the improve_sqlite_like_lazy_eval branch May 6, 2024 16:47
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Development

Successfully merging this pull request may close these issues.

1 participant