On Fri, Jul 30, 2010 at 5:24 PM, Alexey Pechnikov <pechni...@mobigroup.ru>wrote:
> 2010/7/31 Richard Hipp <d...@sqlite.org>: > > (3) Read about the sqlite3_stmt_status() interface. Just before you > > sqlite3_finalize() or sqlite3_reset() each prepared statement, using > > sqlite3_stmt_status() to see how many full-scan steps and how many sorts > it > > had to do. If the answer to either question is non-zero, you found a > > potential place to optimize using an index. > > It's new for me and really interesting possibility. Can we use this > feature from tclsqlite interface? > Assuming the database connection object is named "db", the commands are: db status step db status sort db status autoindex > > -- > Best regards, Alexey Pechnikov. > http://pechnikov.tel/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- --------------------- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users