Hi list, I was told that indexing greatly enhance the speed of SQlite, however, i was cautioned that it comes in as an overhead, in terms of increased size of the database.The Database, that I am handling, isn't larger. Also, I was told, that one should watch, where to create the indexes. I have created index after creating the table in the database.Should I create the index, at the end, when all the data gets itself into the database ? Also it would be nice to know,if the inserts are slower when we are adding data to the table with indexes already applied to it ? General guidelines about indexing will be greatly appreciated. Thanks in advance, Atul
-- View this message in context: http://www.nabble.com/Where-to-create-index%2C-a-doubt-...-tp25693438p25693438.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
