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"]))
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 PLANshows 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: