Here is my situation: I have a SQLite table that has a customer id, the folder id, and the image id (filename). This is a favorites table, so for a given customer and folder, there is going to be a small set of images in the table.
The operation is to scan the folder/directory on the HD for all the images and return that list with a flag indicating if the image is in the favorites table. The expectation is that for a given customer and folder there will be less than 10 images selected. What would be faster, preparing the SELECT statement and running it for every file found or getting all the images for that customer in that folder, storing in a STL map and looking up the subset in the STL map? Or is it such a small difference either will work? Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users