We're in the beginning process of upgrading our Orion DB and our DBA team requested the following:
"We are thinking about partitioning data files base on data time, so the historical data can be put in different data file/file groups with the current data. Is there any document I can read for the definition of these data files and file groups? I saw several file groups in the db, and one file group names as TIMESERIES, but don’t know what’s the data in this file group."
A. Are there any issues with they doing this, that anyone knows of?
B. Is there anyone out there who's done this, and if so did it improve the performance?
C. Thoughts on the TIMESERIES question? I'm not sure what the filegroup TIMESERIES is, I have my guesses, but I want to know for sure.