If you can give us a database dump of the archive table and put a
compressed version of that online someplace we can pull it from, it might
be easier for everybody.
The command should be something like:
echo ".dump archive" | sqlite3
/path/to/your/database/mydatabase.sdb | gzip - > db.dump.gz
On my m1 mac mini it takes 33 seconds for my database that is 471,695,360
in size, so about 2/3 of your unusually large database. It would take a
long time on a raspi.
Please don't post your whole db here, it's far too big. Put it online
someplace we can download it from.
--
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/dec1d15b-8545-4d41-8dda-aef7f9c66e7fn%40googlegroups.com.