Lee Crain wrote: > > Could improvements in search and access performance be realized by > indexing this table?
Yes, if your searches are of the type that can use the index. > Or, might having an index actually decrease table > write and/or read performance? Adding indexes will always decrease write performance since both the table and the index must be updated. The real question is whether the costs of the index in space and write performance pay off in enough increased read performance in the common search cases to make it worth incurring those extra costs. In short, as usual, it depends. :-) HTH Dennis Cote _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
