Re: [sqlite] temp tables or virtual tables, which is faster?

2009-06-09 Thread Alexandre Courbot
> 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 tabl

Re: [sqlite] temp tables or virtual tables, which is faster?

2009-06-09 Thread Sam Carleton
On Tue, Jun 9, 2009 at 10:17 PM, Alexandre Courbot wrote: > > > 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 th

Re: [sqlite] temp tables or virtual tables, which is faster?

2009-06-09 Thread Alexandre Courbot
> 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

[sqlite] temp tables or virtual tables, which is faster?

2009-06-09 Thread Sam Carleton
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