Oh, thank you very much for the quick reply. I am still rebuilding the new server and had noticed this delay again. Archiving sometimes took several minutes and there was also an error message: This was someRe: [weewx-user] High load on the database
Tom Keffer schrieb am Donnerstag, 5. September 2024 um 14:11:05 UTC+2: > 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/46321a80-4103-4371-87cf-bf4d211b9a88n%40googlegroups.com.
