autoimport does not correctly use index
lieryan opened this issue · 1 comments
Describe the bug
Related conversation:
@MrBago made an IPython notebook testing the performance of an unrelated query. This brings up an unrelated performance issue with the search_by_module_like and likely the other like queries as well.
A prefix search using an index should not have been that slow. Indeed, it doesn't seem to be correctly using the index as EXPLAIN QUERY PLAN shows that it is doing a full table scan on the LIKE query so the index doesn't seem to be defined correctly, I think this is because of a case sensitivity issue on the index.
To Reproduce
Steps to reproduce the behavior:
In [78]: %time _ = list(autoimport._execute(m.Name.search_module_like.select_star(), ["abc"]))
@lieryan are there any updates on this issue? Do you have an ETA when you want to do this? I have capacity to work on this, so I am happy to help!