"Lee Crain" <[EMAIL PROTECTED]> wrote:
> I am debating the performance gains to be realized, if any, by indexing a
> particular table in a system implementation for which I am responsible. 
> 

You are getting way ahead of yourself.

Stop trying to speculate about whether or not an index
or indices will be useful.  Write your application first.
Then test it.  Measure the speed.  Then add an index and
test and measure again.  Compare the measurements.  Add 
a different index or combination indices.  Repeat until 
done.

Premature optimization leads to bad design.  Build your
application first, then measure it to see where optimization
is needed.

--
D. Richard Hipp <[EMAIL PROTECTED]>


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to