-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hardy, Andrew wrote: > How ever the elapsed time in the profile always shows zero. > > Does any one have a guess at what I may have left out?
The granularity of the timers on your operating system is greater than the amount of time it took to execute the query. In my tests for the profiling functionality I create a table containing 100,000 rows each with a random integer. I then find the maximum value with and without an index. You don't say what operating system you are using but are using a Windows mailer. SQLite uses the GetSystemTimeAsFileTime API on Windows to get the time. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIwbDhmOOfHg372QQRAiIFAJ43YFzUZU5OjRh7dOZSZIT01xp7owCfTUsp whtsGoLZvvRO80iXjqguDfM= =wEbR -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
