Cleaning series_data

[Jochen Wiedmann]

Thanks for the suggestion, I'll try that.


2010/7/30 Frédéric Buclin <lpsolit at gmail.com>:
> Le 30. 07. 10 10:26, Jochen Wiedmann a écrit :
>> Is it possible to purge this data before the migration and run
>> "collectstats.pl --regenerate" afterwards?
>
> collectstats.pl --regenerate will only regenerate data for old charts,
> not data for new charts. So you would loose a lot of data if you purge
> the series_data table. I'm surprised it takes so long for the conversion
> as this table mostly contains integers. Not sure what's the best thing
> to do, though.
>
> Maybe you could store the series_data table elsewhere, upgrade your DB
> with an empty series_data table, then copy the content of the copied
> table into the upgraded (and empty) one. As there is a series_date
> column, there is no risk to conflict with new data which could be added
> while you populate this table.
>
>
> LpSolit
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=jochen.wiedmann@gmail.com>
>



-- 
Germanys national anthem is the most boring in the world - how telling!