Hi, Simon. > Question 1: What are the units ? > > Question 2: I would have expected consistency in that user time was always > greater than system time. Or perhaps the other way around. Why is a different > one greater for the two examples ? >
System time may be much greater if it involves a lot of tasks performed by OS. For the sqlite part, it's probably reading data from database file. Specifically it's lseek() and read() libc functions. On the outher hand, I doubt that sqlite's part in that time value is big. If I understand correctly the result of SELECT has returned a lot of data. Specifically that data was writen as an output to your console. If this is the case, a lot of system time was wasted just to write the results. It may be because each written line calls fflush() on stdout. Regards, Paul _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
