Large Database on C/Side

bbrown

Only limited by your budget and design imagination. Actually the database where this design first came up was 120+ GB.

Waldo

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.

kriki

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.

Waldo

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.

For that, I absolutely agree ... =D>