Previous Topic: Estimate CSE SizeNext Topic: Capacity Planning Checklist

Capacity Planning › Split Files Across Multiple Physical Drives

Split Files Across Multiple Physical Drives

If physical disk resources on the encyclopedia server permit, splitting files across multiple physical drives will improve disk performance. DOBJ and DASC are the largest and most frequently accessed tables in the encyclopedia. Placing them on separate drives, as well as their indexes, can significantly improve performance. DSUBEX is heavily accessed during subset download; performance will also benefit by having that table and its indexes on different drives.

The following configuration will provide the best possible disk performance:

Drive

Contents

A

DBMS log files

B

DBMS rollback segments (if applicable)

C

All tables except DOBJ, DSUBEX, and DASC

D

All indexes except those for DOBJ, DSUBEX, and DASC

E

DOBJ table

F

DOBJ indexes

G

DSUBEX table

H

DSUBEX indexes

I

DASC table

J

DASC indexes

You need not distribute data manually if CSE database files reside on RAID disks that already use striping (for example, RAID 0, RAID 1, RAID 3, and RAID 5). It is suggested by most DBMS vendors that log files not be striped, as log records are inserted and retrieved sequentially.