I don't understand how partitioning helps me more or less than using a separate table to store older records.
I need to maintain a list of stock entries along with historical records about the stock.
So here I have the option that if some stock is discontinued, I can move that stock to another table that will be accessed only at the time of reports when a user wants to see old data.
Another option I have is partitioning the table, but as I don't know much about partitioning I am not sure if this will really help me.
Stock records will be accessed each time stock is removed from inventory. Once the remaining quantity reaches 0, the item needs to remain in the table for reporting purposes only. A new entry is created upon purchase of further stock.
I have gone through the dev.mysql documentation on Partitioning.
Questions
- Can anyone shade some light on this ?
- Is this the right way of doing this ?
- Should we handle it differently ?
volumes
it will grow with time butactive
records will be limited to a few hundreds or thousand only.