Large Database on C/Side

kriki wrote:

Waldo wrote:

bbrown wrote:

A recommendation I got from Navision on time (pre-MS), was to split the database and place each file in its own RAID 10 array.

I heared this as well ... but don't you think times has changed, and this is not necessary anymore?

Indeed, you can still use this approach:
How about a 1 GB-DB divided in 16 DB-files with a 6-disk RAID10 per DB-file :!:
If this goes slow, I want to know the programmer who programmed everything!

kriki wrote:

Waldo wrote:

kriki wrote:

Waldo wrote:

bbrown wrote:

A recommendation I got from Navision on time (pre-MS), was to split the database and place each file in its own RAID 10 array.

I heared this as well ... but don't you think times has changed, and this is not necessary anymore?

Indeed, you can still use this approach:
How about a 1 GB-DB divided in 16 DB-files with a 6-disk RAID10 per DB-file :!:
If this goes slow, I want to know the programmer who programmed everything!

Yes off course this is (still) the most "performant" way to go ... RAID 10 is the fastest RAID set... but still ... is it worth the cost ... that's my question.

Well, for a 1 GB-DB, this is just 'a little' overkill. But it might be worth the cost for an over 100GB-DB.