Hi cstrader, Just send some table structure and the explain what you are trying todo. In my opinion it is not a good way to deal with 2400 tables :)
ugumugu cstrader yazm?s,: > 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 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users