I think if you try this with MySQL MyISAM you will have the same result and
I
think this is to do with the SELECT *
I remember I used to have something similar back in the days when I tried
MySQL.
Charlie
==============================================
I just tried adding extra conditions in the ON clause, but its not helping,
I think SQLite is still putting the tables all together before doing the
conditions which is whats taking so long. Never mind though, I think I can
manage it with subqueries and UNIONs faster, don't really wanna switch to
somethin else, though access would be possible, I don't know if it would be
at all efficient with all this data.
