I'm working on an Business Intelligence application where customers will
be adding values about different indicators. For example "Blue cars sold
daily", then every day a record is stored representing that indicator.
So there can be many indicators and many many more values for each
Right now everything is living in the same DB. Since the amount of
values can be huge after some time I'm now wondering if the values
should be stored in a different DB somehow.
I imagine the auto-increment IDs might someday restart and cause a nasty
issue if IDs that are used for the associations of the other objects get
Should I be worried about this and move the values storage to a separate
space? Any good suggestions?