Am 26.01.2012 18:45, schrieb HalXsz SXndor:
> 20120126 10:34 AM +0200, a bv
> Database contains
> tables (structures?) which gets montly data , and these tables are
> named as
>
> name1_name2_ yearmonth . I only want to have the whole database system
> for last 2 years, and automaticly
The original problem is traditionally resolved by partitioning the tables by
historical range and creating a database job/event to drop older partitions and
add the new ones. Depending on the environment, some might prefer shell
scripts to do essentially the same.
On Jan 27, 2012, at 3:08
- Original Message -
> From: "Halász Sándor"
>
> Therefore, it well may be easier to do it all in PHP, since therewith
I agree with the assessment, but I take issue with this whole "do it in
PHP/Python/language-of-the-month".
Why would I want to install PHP, Python or whatever on a da
20120126 10:34 AM +0200, a bv
Database contains
tables (structures?) which gets montly data , and these tables are
named as
name1_name2_ yearmonth . I only want to have the whole database system
for last 2 years, and automaticly clean the data which became more
than 2 years old , so i ne
