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

Reply via email to