My apologies. I misunderstood. 1M rows is not a particularly big database. That's about the size of mine (10 years of data, 5 minute interval), which causes no problems.
I would focus on the corruption issue and don't worry about reducing its size. -tk On Fri, Sep 29, 2017 at 12:09 AM, stefano siega <[email protected]> wrote: > Hi, Tom > > Thanks for the reply. > But this is not what I really want to do. > > I want to reduce the archive table dimension by 5. > I have a corrupted database with more than 1,000,000 rows in archive > tables (1 minute interval) and I have reduced the same by 5, to about > 200,000 rows with excel. > > Now I miss the latest information I asked for. > > Then I'll rebuild the database with te command wee_database > --rebuild-daily. > > > Il giorno venerdì 29 settembre 2017 00:42:45 UTC+2, Tom Keffer ha scritto: >> >> Hi, Stefano >> >> Since you wrote your original post, V3.7 came out, which *does* allow >> the archive interval to change within a database. All you have to do is >> update your database using the tool wee_database with option --update. >> >> See the Upgrade Guide for details >> <http://weewx.com/docs/upgrading.htm#From_V3.6_or_earlier>. >> >> Truth be told, if you do this, you would be the first to try it, so I'm >> eager to hear about your experiences. Make a backup first! >> >> -tk >> >> On Thu, Sep 28, 2017 at 11:52 AM, stefano siega <[email protected]> >> wrote: >> >>> Hi all. >>> >>> I'm finally working on the database to reduce it. >>> >>> I converted the archive table to CSV and I started creating the >>> functions to make the values average. >>> >>> rain needs to be summed? >>> rainRate needs to be summed? >>> >>> windDir needs to be averaged? >>> windspeed needs to be averaged? >>> >>> >>> The value interval must be changed to 5 >>> usUnits value remain to 1? >>> >>> And finally ... The values that have been averaged have now more >>> decimal numbers. Can you attach a small database (interval 5 minute) of a >>> davis vantage 2 to figure out how many decimal places after the comma I >>> have to leave for any value? >>> >>> thank you so much >>> >>> -- >>> 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. >>> >> >> -- > 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. > -- 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.
