Is it helpful to split a table in several files (i.e: by months) and not split them in the equal amount of physical disks?
Considering only the last 2-3 months should be heavily used, is it helpful to split those 2-3 files in 2-3 disks and have the others bulked together, would this increase performance?
Not a direct question and i sense a "it depends" coming, but just want to know if its helpfull at all.
Ill properly test this as soon as i can but right now its not possible due to time constraints.
--
Thiago Dantas
@DantHimself