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
