Not the OP, but for a random datapoint on a slow machine that is capable of weewx, I ran the query against a DB that starts roughly 2017-12-26, on a 1G RPI3 with filesystem on uSD, and got no rows and:
Run Time: real 17.919584 user 1.634768 sys 1.655089 The same query for outTemp sqlite> SELECT dateTime, outTemp FROM archive WHERE outTemp IS NOT NULL ORDER BY dateTime DESC LIMIT 1; ╭────────────┬─────────╮ │ dateTime │ outTemp │ ╞════════════╪═════════╡ │ 1785889200 │ 72.4 │ ╰────────────┴─────────╯ Run Time: real 0.000624 user 0.000455 sys 0.000182 -- 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/rmiv79pbejf.fsf%40s1.lexort.com.
