Re: Small database - No. Disks

I would have to say that the answer to your question would depend on whether you are satisfied with the performance of the db the way it is. Obviously, OnLine could benefit from having multiple spindles to handle temp ops, indexing, logs, etc but based on the size it may not be worth the additional expense and complexity. scd dave@columbo (Dave McCreery) wrote: >We use Informix On-line as the database in our application. The database is >normally very small takink up an initial size of 150Mb and never growing to >more than 600Mb. This is not a large datbase and can easily fit onto the >average size disk on most UNIX machines (1Gb). So is there any advantage to >adding extra disks to spread my rootdbs, Physical log etc. >The system is mostly READ-ONLY & some UPDATES during the day & a large amount >INSERTS & DELETE (up to 35% of the database is deleted and reinserted by nite) >at night. >Any statistics or rules of thumb - keeing in mind that the database is small - >would be appreciated. >Thanks >============================================================================ >David McCreery Technical Support >Credo Electronic Banking Dublin, Ireland. >============================================================================ >. ____________________________________ Stephen C. Dickey Corbett Systems Development PO Box 2347 Colorado Springs, CO 80901-2347 303.674.0700 voice 719.520.9092 voice 719.633.8594 fax scdickey@corbsys.com 70651.2370@compuserve.com ____________________________________