> I have now learned about the concept of virtual tables. Am I better > of with my current approach because I can index the files in the temp > table, or would I be better off using a virtual table to scan the hard > drive for the images?
Depends on how often you must reindex and how critical it is for you to be up-to-date. A virtual table will ensure you do not have any synchronization problem. On the other hand, if your temp table is indexed, you may expect it to be faster. You do not tell much about your join conditions. > Also, since the only writing I am doing is to a temp table, can I > connect to the SQLite database with read only? When I need to be such things, I just set my database file to be read-only at OS level. :) Alex. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users