Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Slow "for" ~100ms #1

Closed
kaihendry opened this issue Mar 14, 2021 · 3 comments
Closed

Slow "for" ~100ms #1

kaihendry opened this issue Mar 14, 2021 · 3 comments
Assignees
@kaihendry

Comments

@kaihendry
Copy link
Owner

  • Query: for Results: 1176 Time taken: 89 ms
  • main.go:87: Performed query "for" in 69.174022ms
  • real 0m0.035s via time ./search.sh
EXPLAIN QUERY PLAN
select word from words where "word" like "${1:-for}%"

is

QUERY PLAN
`--SCAN TABLE words USING COVERING INDEX words_index_1
@kaihendry kaihendry self-assigned this Mar 14, 2021
kaihendry added a commit that referenced this issue Mar 14, 2021
@kaihendry
Show how long it too to do query from Go for
117b8b4 
#1 debugging
@kaihendry
Copy link
Owner Author

On https://dfts.dabase.com/ it's must slower unsurprisingly.

@kaihendry
Copy link
Owner Author

CGO_ENABLED=1 https://github.com/mattn/go-sqlite3 version is twice as fast https://twitter.com/benbjohnson/status/1370936353572130816

But that makes deployment require a cross compile.... aka a total PITA! apex/up#825

@kaihendry
Copy link
Owner Author

fts5 might also address the slowness https://gist.github.com/egonelbre/900c4f1b3dbe19f1455526affb7f9e37 via https://twitter.com/egonelbre/status/1371036641662484483

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kaihendry kaihendry

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@kaihendry