On 5 Apr 2011, at 8:47pm, Guilherme Batista wrote: > Yes it's true. > But I'm not trying to improve the SQLite performance. I'm just studying the > query optimization of databases in general, and a better way to optimize if > the tables do not have indexes and if the query is complex and deals with > big amount of data. It may probably be useless but it's just a study.
Oh okay, I get it. In that case you can't do better than study the source code for SQLite. That way you'll know exactly how it works. And you can insert your own diagnostics (print statements) in it and compile your own version, which gives you all the internal information you need. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
