>hi,
>I am developing stock control system. Recently, my client complain that my report generated very slowly. According to my investigation, it is because amount of data. This client has 25,000 products. Also, it could has 500 sales records and average 30 lineitems per sale within ONE DAY.
>Therefore, I am worry about the performance of the query.
>I was told that we should purge our data periodly.
>Could you please give me some ideas?
>Where does the purged data should be stored?
>Could it able to be restored?
>Once purged, how could I refer to previous data when necessary? Do you generate summary record for each table or...?
>
>Pls advise
>
>Thank you
While you may still want to archive your data, I think you also need to optimize some queries. After all, you will at least want to have data for several months,
without having to go to your historical archives.
See my FAQ #8109, on query optimization.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)