My sqlite database has about 2 million data records (dates back to 2007) with no performance issues. Your MariaDB database should be able to easily handle 1 M.
Tags like $alltime will cause searches of the whole database, which can be slow. But, a tag for a year ($year) should not be a problem. There must be something else going on. What are the symptoms? On Thu, Sep 5, 2024 at 5:01 AM J. H. <[email protected]> wrote: > Hello, > > My mariadb database has approx. 1 million data records and the data goes > back to 2019. This leads to a high load on the database. Are there any > instructions or commands to reduce the size of the database, especially > since only the year and month view can be displayed? > > -- > 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 on the web visit > https://groups.google.com/d/msgid/weewx-user/1518783c-0032-4145-9ce1-49616450455dn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/1518783c-0032-4145-9ce1-49616450455dn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEAiHAHTXsXOACo642gGeoZZy4LfxYtT1QbrA6_y3d6djQ%40mail.gmail.com.
