Hi, Bill. 1. WeeWX can handle mixed intervals. 2. The time, field dateTime, is indexed, so it does not slow down reports as much as you think. My database is about 1.5 M records and it performs fine on a very slow machine. The exception is queries that involving finding the min and max of the whole database. 3. If you decide you want to consolidate into 5 minute intervals, user Cameron came up with a guide that uses some clever SELECT statements to do the job. Find it on the Wiki <https://github.com/weewx/weewx/wiki/Data-Consolidation---changing-sampling-interval> .
-tk On Thu, Apr 16, 2020 at 1:47 AM William Burton <bburton...@gmail.com> wrote: > Hello, > > I've been testing a CSV import configuration with wee_import. The CSV data > is in 1 minute intervals whereas weewx.conf has an archive_interval = 300 > for 5 minutes. my csv.conf has interval = 1 to match the data interval > (which has a few gaps). > > What I'm finding is the imported data is still in one minute intervals > while data archived from the driver has five minute intervals: > > sqlite> select interval, count(*) count from archive group by interval; > interval count > ---------- ---------- > 1 51234 > 5 12259 > > 1. Will having mixed intervals in the same database cause any issues > with reporting such as incorrect time scales in graphs? > 2. Wouldn't archive records with a one minute interval slow down > report generation? > 3. I calculated that I have around 900 files to import for a total of > almost 1.3 million records. If these records could be averaged to only one > record per five minutes, then it would be only 260,000 records which seems > more reasonable. > > I'm using WeeWX 4.0.0b18. > > Thanks for any assistance, > -Bill > > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/0151a436-a259-4c12-be92-c20c5e796711%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/0151a436-a259-4c12-be92-c20c5e796711%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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEBY_YioiXhkJ150C9YhQoRhFgYfzjEpkWKMf3%2BepM92uA%40mail.gmail.com.
