I am working on a web based kiosk system that displays images to 1 to 50, maybe 100 viewing stations.
Currently I am using the file system (Windows) to store the images and to do lookups on the images. At one point I need to do a join between the images and a table (containing details about some of the images, such as which ones are selected). Currently the code opens a read/write connection to the database, creates a temp table, populates the temp table with all the files (upwards of 1000), and than uses the temp table to do a join against the table of selected images. 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? Also, since the only writing I am doing is to a temp table, can I connect to the SQLite database with read only? Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
