Skip to content
New issue

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

#

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

Already on GitHub? # 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

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

@kaihendry kaihendry

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@kaihendry