Performance question : number of volumes
A general question about what "it should be" for good performance :
i have a database that always grows (quite nothing is deleted), due to regulary text files imports and human data entry.
Actually, i have one volume of 10 Gb (where datas use half the size).
The database is stored on the production machine, that use a raw space on a "standard" disk.
1) would it be better to have more than one volume, but smaller, for example 1 Gb per volume ?
2) I will have soon a new machine with raid 10 disks. Does it make sense to have more volumes too (on raw space) ?