On Saturday, October 13, 2018 at 10:19:15 AM UTC-7, CCOR58 RADIO wrote: > > Ok I see that the "archive" table is the master I would expect to see > but am confused as to how/why all the other tables are created. Are > they derived and updated from the archive table with individual update > queries that run each time the archive table has a record added? > > yes
> If something in the archive table is manipulated manually will it be > reflected in the archive sub tables or do they have to be modified / > updated manually as well? > > yes > If data from the archive table was way out of range for some > maintenance procedure reason on the senors would deleting those records > manually need to be done to each of the sub tables as well? > > yes - although you'd generally drop the table and weewx would regenerate them automatically > Are the subtables created as child recordsets of the main archive table > in order to allow some generated reports to access data more quickly ? > > yes > Why do those reports just not run specific queries for that specific > data selecting from the main table rather than creating extra separate > tables? > you already answered that. Speed. -- 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]. For more options, visit https://groups.google.com/d/optout.
