On Tue, 18 Nov 2025 at 04:06, Pablo Sanchez <[email protected]> wrote:

> One thought is to to ensure that the data types also cover metric.
>

I store data as metricwx...

In any case the tuning steps would be the same for imperial, check columns
for unique values, and set columns number types accordingly...

However the biggest saving was changing the columns from double to float,
this would nearly halve things because you go from 8 bytes per value down
to 4 bytes, there is no need for using double because that allows for 16
decimal places of precision and a much bigger numbers as well which is well
beyond what's needed when only 1 decimal place is usually required.

-- 
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/CAGTinV6z7FbXMXwm3EniSQMbvh9xVTmj1s51pCU2fxQFSocRUw%40mail.gmail.com.

Reply via email to