Re: [sqlite] 5000 tables with 3000 records vs 1 table with 15000000records

2010-08-22 Thread Simon Slavin
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 su

Re: [sqlite] 5000 tables with 3000 records vs 1 table with 15000000records

2010-08-22 Thread ve3meo
"Mike Zang" ... > In fact, the file is stock data and one file is for one stock, so they are > all in the same format. > > Then, in most case, only one stock should be selected. > Then, from a 'disk' operating system and memory management perspective, wouldn't one file per stock continue to be fa