Hi, Tim On Tue, Mar 20, 2012 at 6:21 PM, Tim Morton <[email protected]> wrote:
> > Is there a way to read only the part of the file that has the queried > table/column thus saving time and hard dive grinding? > > There is also a trick. You can create an index on 'topics' column and perform your first reading forcing this column order and not touching definition at the same time. Since any index is just another b-tree but most of the time smaller you will end up reading a smaller part of file. Although there's a price to pay, your db will become larger. Max _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
