Subject | Tuning question |
---|---|
Author | David Johnson |
Post date | 2004-12-06T04:37:02Z |
I'm sure the answer to this is in Helen's book, but I have to wait until
after Christmas to get my copy (just in case Santa brings it), so I'll
post this question to the gurus on the list.
On heavily loaded Oracle and DB2 databases we often specify separate
physical media for the tables and indeces to improve performance. In
one recent installation, we actually specified four separate physical
media devices. One for the tables, one for the indeces, one for the
logs, and one for the audit tables. This installation decision means
that the I/O for our applications is very efficient and there is very
little contention for DASD resources.
Does Firebird offer this level of control? For now, a "Yes" or "No"
answer is sufficient. By the time I need to know "how", I can have
Helen's book.
Thanks in advance.
after Christmas to get my copy (just in case Santa brings it), so I'll
post this question to the gurus on the list.
On heavily loaded Oracle and DB2 databases we often specify separate
physical media for the tables and indeces to improve performance. In
one recent installation, we actually specified four separate physical
media devices. One for the tables, one for the indeces, one for the
logs, and one for the audit tables. This installation decision means
that the I/O for our applications is very efficient and there is very
little contention for DASD resources.
Does Firebird offer this level of control? For now, a "Yes" or "No"
answer is sufficient. By the time I need to know "how", I can have
Helen's book.
Thanks in advance.