Thanks,
I may try this, but the topics are usually just one word each so I doubt
an index could reduce it much.
Tim
On 3/20/2012 1:52 PM, Max Vlasov wrote:
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
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
