Hi Greg, Let’s assume that is the cold scan. Would you run twice in a row and give me the second time for a warm scan?
> On Aug 4, 2026, at 5:24 PM, Greg Troxel <[email protected]> wrote: > > 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. -- 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/3073EB33-9379-4A7B-9E83-E3EAC0559FE6%40johnkline.com.
