4 ms·
Ask HN: Optimising very slow query
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 8y agoHow 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?