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.
Will see what I can come up with.
Oh and I am talking of the NSLU2 here. So thats pretty memory constrained.