You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Nov 25, 2023. It is now read-only.
Just tried to make search request on 2.5M rows on SQLite / FTS5 and seems that we starting to have performance issue.
According to following conversation we need to rewrite current DB driver model. Suppose MySQL is the nice accessible alternative.
I have experience with Sphinx engine, it stores compiled data in RAM and able to process at least 8M rows in milliseconds with same server resources, comparing to the current result.
If some one have better ideas - you are welcome here.
The text was updated successfully, but these errors were encountered:
Just tried to make search request on 2.5M rows on SQLite / FTS5 and seems that we starting to have performance issue.
According to following conversation we need to rewrite current DB driver model. Suppose MySQL is the nice accessible alternative.
I have experience with Sphinx engine, it stores compiled data in RAM and able to process at least 8M rows in milliseconds with same server resources, comparing to the current result.
If some one have better ideas - you are welcome here.
The text was updated successfully, but these errors were encountered: