Thanks. There are a lot of records in this table. It is written to infrequently, read often.
Based on your comments, I'd have to guess that it would be best to index it to achieve better read performance. Thanks, Lee P.S. I've sent my original email to the SQLite forum several times because our mail server is showing that it was rejected. Obviously, this is not true. I apologize for the extra sends. ---------------------------------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote Sent: Friday, March 14, 2008 1:03 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Efficiency Question - Value Or Liability for Indexing of This Table? 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
