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
