> I'd like to know if there are differences between the optimizers in the > sqlite in-memory DB and on disk DB.
No, there's only one optimizer in SQLite. > Is there a way to narrow down the measurement of time to see where the time > is spent? How do you want to narrow it down? Maybe you want to use any sort of profiler - it will show you time spent in different SQLite functions. Pavel On Mon, Dec 6, 2010 at 10:03 AM, Schoinya <sunny_a42...@yahoo.com> wrote: > > Hello everybody > > I'd like to know if there are differences between the optimizers in the > sqlite in-memory DB and on disk DB. I mean, whether there are different > optimizers which are applied as default, that can make difference between > IMDB and on disk DB, in terms of query execution time. > > Also, for the small experiment I tried to measure the query execution time > as > > startTime = DateTime.Now; > cmd.ExecuteNonQuery(); > endTime = DateTime.Now; > > timeDif = endTime - startTime ; > > Is there a way to narrow down the measurement of time to see where the time > is spent? > > Thanks in advance > -- > View this message in context: > http://old.nabble.com/Optimizers-%3Amemory%3A-mode-tp30366720p30366720.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
