The database version number only comes into play if you change your archive interval. Higher versions "weight" the result by the length of the interval.
One of my databases, now 18 years old, is still at V1. On Wed, Dec 27, 2023 at 6:12 PM 'Cameron D' via weewx-development < [email protected]> wrote: > Tom, > my question was not from the MySQL side, but because you said the weewx > code consults the database to see if it can "do that type". > In any case, I since realised tha I am seeing the same problem with the DB > converted to sqlite, so that cannot be a cause. > > On a side question, is there much significance to the "version" number in > the DB metadata? I see one of my DBs is version 1 and the other is V4? > > Cameron. > > On Thursday 28 December 2023 at 10:52:26 am UTC+10 Tom Keffer wrote: > > On Wed, Dec 27, 2023 at 4:18 PM 'Cameron D' via weewx-development < > [email protected]> wrote: > > Tom, > is there any chance that it is confused by me using mysql storage type of > float rather than real? > > > I'm not a MySQL expert, but I doubt it. > > WeeWX does lots of little queries, which MySQL doesn't do as well as > SQLite. It's possible that V5 is doing something that aggravates that. > > -- > You received this message because you are subscribed to the Google Groups > "weewx-development" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-development/db5da043-0192-417a-ab27-838a82ebb47bn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-development/db5da043-0192-417a-ab27-838a82ebb47bn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/CAPq0zECNJU3p9LTQTcgnxrsZ0EE4pACKWqh_0AYcmYSDN-r15Q%40mail.gmail.com.
