On Tue, 18 Nov 2025 at 05:19, vince <[email protected]> wrote: > Disk is cheap. The db is not in memory so size of the db does not matter.
What program doesn't use memory to perform actions on data? That statement makes no sense. Further to that MariaDB can cache lots of data in spare memory to speed things up. > Weewx uses a small amount of memory. I used to run it on an ancient ARM > box that had 128 MB of RAM. It ran fine. > Where did I mention weeWX? All my comments relate to MariaDB. > For my sqlite3 db.... > > archive table is 439 MB in 1,866,971 records > the entire db is 501 MB > for a couple weeks short of 19 years data > I have data back almost that far as well, but now my DB is a fraction the size it used to be without any downside than a little DB tuning... > concluded it was worth the flexibility to cook up the wview_extended > bigger schema rather than to try to try to > I also covered this point, that removing unused columns and needing them later I would end up with all the NULLs they previously had, but if I don't use them I don't waste resources on them. -- 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/CAGTinV4W2c_-WXJs6QBWUQ-6rdKg%2Bc-hMi-%2B3ZPdjXT8Y0APxA%40mail.gmail.com.
