On 22 Aug 2010, at 6:34pm, ve3meo wrote: > A master database with pointers to > each of the stock databases, ATTACH as many as you want to view at one time, > maybe combine data into temporary table(s), create and drop indexes on the > fly thus keeping storage at a minimum.
I was going to suggest something else. If you think you might ever want one application to report on two stocks in the same run, then use one huge file with all the data in. If that makes no sense, and you would never compare/total/merge stocks on the same display, then use separate files. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users