Re: RAM requirements- new server

[A B]

Hi,

- I have begun innvestigation into partitioning, in our case horizontal partitioning by Month, would be the way to go. Perhaps use 12 partitions one for each month) and archive to yearly tables after that.

For us, it would simplify a number of webpage queries and improve the responsiveness, as well as simplify our archiving process.

- What is also good about partitioning is that we can do this on our existing tables whilst running live and insert old data back into the newly paritioned tables, rather than having to create new tables and insert ALL data into them.

- I assume then that the table would need to be optimised/re-indexed or would that happen on the fly, as well?



I can see the benefit of vertical partitioning in some cases, and perhaps even in some of our work, although this would need to be determined.


thanks again,

A