One of the tenants I've always adhered to when tuning RDBMS is that logfiles
and datafiles should always be on separate physical devices if at all
possible in order to exploit the nature of sequential reads vs. writes.

Is there any reason this strategy should not be applied to an IFX
installation?

What would you suggest as an optimal strategy (in broad strokes as I
understand much of this is situational...) for laying out datafiles vs.
logs?


Thanks Friends,

Tam.

Tam O'Shanter said:
> One of the tenants I've always adhered to when tuning RDBMS is that
> logfiles
> and datafiles should always be on separate physical devices if at all
> possible in order to exploit the nature of sequential reads vs. writes.
>
> Is there any reason this strategy should not be applied to an IFX
> installation?
>
> What would you suggest as an optimal strategy (in broad strokes as I
> understand much of this is situational...) for laying out datafiles vs.
> logs?

It's one of the tenets I've adhered to. Adhering to tenants could be
considered stalking, you know. ;o)

I like to have a separate spindle (or spindles) each for root, llogs,
plogs, a different set for temp and a different set for data, as many
spindles as possible.

Of course, you can't always get that, but that's what I like.

--
Bye now,
Obnoxio

"... no bill is required as no value was provided."
-- Christine Normile

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

Are you going to charge me rent for this answer?

Tam.

"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message
news:mailman.149.1162302710.29126.informix-list@iiug.org...
>
> Tam O'Shanter said:
>> One of the tenants I've always adhered to when tuning RDBMS is that
>> logfiles
>> and datafiles should always be on separate physical devices if at all
>> possible in order to exploit the nature of sequential reads vs. writes.
>>
>> Is there any reason this strategy should not be applied to an IFX
>> installation?
>>
>> What would you suggest as an optimal strategy (in broad strokes as I
>> understand much of this is situational...) for laying out datafiles vs.
>> logs?
>
> It's one of the tenets I've adhered to. Adhering to tenants could be
> considered stalking, you know. ;o)
>
> I like to have a separate spindle (or spindles) each for root, llogs,
> plogs, a different set for temp and a different set for data, as many
> spindles as possible.
>
> Of course, you can't always get that, but that's what I like.
>
> --
> Bye now,
> Obnoxio
>
> "... no bill is required as no value was provided."
> -- Christine Normile
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>

Tam O'Shanter said:
> Are you going to charge me rent for this answer?

I dunno.

Let's get the basics out of the way: are you a hot babe? If yes, then I
may charge in kind. Otherwise it'll be cash.

--
Bye now,
Obnoxio

"... no bill is required as no value was provided."
-- Christine Normile

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.