On 2/7/06, chetana bhargav <[EMAIL PROTECTED]> wrote: > I am sure that this question would have been asked many times earlier also. > I am new to > this list, can any one point me about some info on indexing in SQLite. The > time efficiency > and space it requires. Some Do's and Dont's about indexing. Probably best place to start is http://www.sqlite.org/php2004/page-001.html
I can't speak about space, but as far as time goes, take a look at http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison As you can see there index creation is relatively fast. Sometimes it even makes sense to create index, execute query and then drop the index. Though this won't save you any space since index will still be created on disk, if I'm not mistaken. -- Nemanja Corlija <[EMAIL PROTECTED]>
