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 has been archived by the owner on Jan 28, 2021. It is now read-only.
$ time srcd sql "CREATE INDEX files_lang_idx ON files USING pilosa (language(file_path, blob_content));++real 0m0.236s
And queried again, and the time processing was reduded from ~15s to ~.3s what is nice.
But then I queried using an aliased column... and ~15s again.
$ time srcd sql "SELECT file_path, language(file_path, blob_content) as lang FROM filesWHERE lang='JSX';"
...
real 0m12.147s
The text was updated successfully, but these errors were encountered:
dpordomingo
changed the title
Indexes over language function does not work with aliased cols
Indexes on language func does not work with aliased cols
Mar 6, 2019
discovered at https://github.com/src-d/empathy-sessions/issues/37#issuecomment-470041061
Then I created an index, following your example to create an index on language expresion
And queried again, and the time processing was reduded from ~15s to ~.3s what is nice.
But then I queried using an aliased column... and ~15s again.
The text was updated successfully, but these errors were encountered: