I rebooted the machine and then ran the query 3 times. $ sqlite3 weewx.sdb SQLite version 3.53.2 2026-06-03 19:12:13 Enter ".help" for usage hints. sqlite> .timer on sqlite> SELECT dateTime, pm2_5 FROM archive WHERE pm2_5 IS NOT NULL ORDER BY dateTime DESC LIMIT 1; Run Time: real 20.939687 user 1.811444 sys 1.555754 sqlite> SELECT dateTime, pm2_5 FROM archive WHERE pm2_5 IS NOT NULL ORDER BY dateTime DESC LIMIT 1; Run Time: real 2.640085 user 1.682205 sys 0.956678 sqlite> SELECT dateTime, pm2_5 FROM archive WHERE pm2_5 IS NOT NULL ORDER BY dateTime DESC LIMIT 1; Run Time: real 2.675249 user 1.669083 sys 1.004916 sqlite>
$ ls -lh weewx.sdb -rw-r--r-- 1 gdt users 242M Aug 4 20:30 weewx.sdb -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/rmimrv1bdxa.fsf%40s1.lexort.com.
