Gary,

I have weeWX running on a Raspberry Pi 2 Model B Rev 1.1

sqlite> SELECT COUNT(*) FROM archive;
788656

wee_database returns no extra info on the command line when running only a 
--rebuild-daily and it takes less than a second:

pi@weatherpi:/var/lib/weewx $ sudo wee_database --rebuild-daily
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database 
'archive_sqlite'
All daily summaries will be rebuilt.
Proceed (y/n)? y
Rebuilding daily summaries in database 'weewx.sdb' ...
Daily summaries up to date in 'weewx.sdb'

Now dropping the daily tables prior to rebuild:

pi@weatherpi:/var/lib/weewx $ sudo wee_database --drop-daily
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database 
'archive_sqlite'
Proceeding will delete all your daily summaries from database 'weewx.sdb'
Are you sure you want to proceed (y/n)? y
Dropping daily summary tables from 'weewx.sdb' ... 
Daily summary tables dropped from database 'weewx.sdb' in 2.20 seconds

Running daily rebuild after drop:

pi@weatherpi:/var/lib/weewx $ sudo wee_database --rebuild-daily
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database 
'archive_sqlite'
All daily summaries will be rebuilt.
Proceed (y/n)? y
Rebuilding daily summaries in database 'weewx.sdb' ...
Records processed: 788000; Last date: 2018-12-31 10:50:00 PST (1546282200)
Processed 788658 records to rebuild 2749 day summaries in 1498.94 
seconds      
Rebuild of daily summaries in database 'weewx.sdb' complete

So something is not running correctly if a rebuild is run standalone 
without dropping the tables first.

-- 
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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to