> Ok, here is what I am doing right now. The idea is to return all the > images in the folder to the frontend and indicate which ones the > current customer has in his/her favorite's.
If your images do not change, I guess you would get good performances by indexing ImageId and using the temp table. As far as I understand, the virtual table would work as well, and would save you some memory, but you have to program it. So in my opinion both options are correct. Alex. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users