> Related question: Is it possible to specify a start file size for
> tables and/or databases in MySQL? I ask because in databases like MS
> SQL Server, you can tell it to start off with a particular file size
> regardless of the initial amount of data which helps in reducing disk
> fragmentation.

If you're asking about MySQL, you should ask this on the MySQl mailing list 
(http://lists.mysql.com/#mysql).

For MaxDB, it is recommended that you 'design' your volume layout to match your 
expected needs. Volumes can be read in parallel, so
- creating volumes on several disks will enhance throughput
- having multiple volumes on the same disk enhances throughput only up to a hardware 
specific limit.

It is of course possible to add volumes later, but if you have the disk space to 
spare, it is better to reserve it right away for your database.

Daniel Dittmar

-- 
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTECTED]


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to