Number of datafiles

Hi.
Considering a database with 80GB (datafile), using a 1+0 array:
What the best configuration to a performance gain, use 2 files 40gb in the same array, or using one file with 80GB.?

And the same database (80gb), using a raid 5 instead raid 1+0, best with one datafile or 2 datafiles?

Thanks



Esio Nunes

multiple files in one file group has very little to do with size directly.
it is usually used when the arrays are on multiple raid controllers, hence you must have multiple files (do not use os striping for heavy load systems)

multiple filegroups each with one or more files can be used so the biggest table can get its own file group, possibly indexes on another, and if there is a large amount of text/image data,

this is so you do not have to defrag the big table