Ask HN: Optimising very slow query

[_6cj7]

I have a very slow query that takes 10s+ time on my machine. I am using SQLite and SQLAlchemy. Here are some details that I posted yesterday on Code Review SE: https://codereview.stackexchange.com/questions/196034/slow-flask-sqlalchemy-query-using-association-tables

Any help is appreciated.

[dozzie]

How about you show the tables, indices, and the SQL query (queries) instead of relying on automagic of an ORM framework? Is it any faster if you create an appropriate SQL query yourself? How does it look like?