@fizze wrote:
I am sure you have your reasons and did a fair share of research and testing before you implemented the DB stuff like you did. 😉
All I’m saying that maybe there are some tricks to avoid having sqlite “attempt” a full table join in memory. Working with hashes and whatnot.
See, that’s where my lack of real SQL knowledge gets me. I’m sure there are techniques that could be used to speed stuff up considerably, just that I don’t know them, and do things the ignorant way. So seriously, if you see something that would help in that direction, I’d be happy to learn it.
— Ron