Re: [sqlite] Odd very SLOW query in SQLITE - Optimizer is not working!?

"Jonathon" wrote in message news:5dd932e10902271602m59107b2fnb8c9838d12b87...@mail.gmail.com > Here is my query: > > SELECT * FROM tableR r > INNER JOIN tableU u ON u.id = r.u_id > LEFT JOIN tableP p ON u.p_id = p.id > ORDER BY p.p_name; > > tableR has about 5 million records. > tableU has 100k re

[sqlite] Odd very SLOW query in SQLITE - Optimizer is not working!?

Hello All, I have a simple query that seems to be going very very very slow. I am not sure why sqlite is behaving this way, which is why I decided to burden you guys with my question. My guess is that the query optimizer might not be able to decipher what exactly I want to do, and thus computes