One feature that would be useful for the sqlite3 command shell would be a mode
where the duration of the operation is reported after the operation runs
(".timing"?). This would make it easy to compare different approaches for
writing a query, formulating and using different indices, etc. Of course, one
can do this programmatically with a simple fixture, but that's work that may or
may not be simple.
Extra points for breaking out sub-timings for different parts of a complex
query so one can see immediately where the bottlenecks are.
This would be a nice companion to the ".expert" feature and make sqlite3 a
one-stop-shop for query tuning.
Randall.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
