On Fri, Jul 30, 2010 at 5:24 PM, Alexey Pechnikov <[email protected]>wrote:
> 2010/7/31 Richard Hipp <[email protected]>: > > (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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- --------------------- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
