Hello, Any idea why there is such a performance hit when I ask for both min() and max() at the same time? Shouldn't it be just as fast as querying them individually?
Nothing else is reading or writing to this data at this time. [14:32 sql04:/opt/pcaskey]$ cat ~/.sqliterc .output /dev/null PRAGMA foreign_keys = ON; PRAGMA synchronous = OFF; PRAGMA journal_mode = OFF; PRAGMA locking_mode = EXCLUSIVE; PRAGMA cache_size = -20000000; .output stdout [14:33 sql04:/opt/pcaskey]$ [14:33 sql04:/opt/pcaskey]$ sqlite3 star2star.db -- Loading resources from /export/home/pcaskey/.sqliterc SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .timer on sqlite> select min(dtime) from intstats; 1416441600 CPU Time: user 0.001000 sys 0.000000 sqlite> select max(dtime) from intstats; 1426999800 CPU Time: user 0.000000 sys 0.000000 sqlite> select min(dtime), max(dtime) from intstats; 1416441600|1426999800 CPU Time: user 221.806280 sys 47.434789 sqlite> sqlite> select count(*) from intstats; 607009116 CPU Time: user 6.341036 sys 20.271918 sqlite> sqlite> Thanks, Paul
