On Wed, Aug 20, 2008 at 6:03 AM, cstrader <[EMAIL PROTECTED]> wrote: > Well it turns out that the db created this way (including the index) is no > smaller than the one with 2400 tables, and the read is no faster! Does that > make any sense?
Do you often pull your data one stock at a time? If so an index on the stock ID column will speed things up. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users