I'm just starting with SQLite (from vb.net) and could use some advice. I have a set of 2400 (could get substantially higher) tables in a single database (each table contains daily stock prices for a different stock). Each table has 9 columns (all text for now) and some several thousand rows. So far so good.
I need to read those tables sequentially and operate on them. It takes about 18 seconds to open each of the tables in sequence. (i.e. loop through 2400 tables with a select command opening each one) First question... does that sound about right in terms of speed? Is there a way to store the data that might be faster? The data are primarily single precision -- I'm using text format, but perhaps that's not best? Second question: When I open each table I need to add some blank columns to it. So I include some "0 as NewCol" lines to create the new columns with initial 0s. However, adding 20 new columns in this manner increases the total time for the loop from 19 seconds to 49 seconds. This seems like a long time. Is there a faster way to get these empty columns in? More questions later I'm sure... Thanks in advance cs _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
