Re: Small database - No. Disks

Dave, Direct emails bounce; please check that your mailer or news system provides a properly qualified email name -- probably something like dave@credo.ei or dave@columbo.credo.co.ei rather than just dave@columbo. Or include your domain-qualified email address in your signature. You get some performance benefit from reduced disk contention if the logical log is on a different disk from the physical log and both are on a different disk than the main database, and all the database is on a different disk from the Unix file systems. This applies to any size of database. Whether it is worth doing is another matter altogether. Given the work pattern, provided there is enough time margin for the overnight processing to complete when the database reaches the 600 MB level, there is no pressing reason to distribute the bits and pieces. On the other hand, if there are (going to be) problems with the overnight work, then splitting the database may provide some improvement, but the biggest improvement will almost certainly be algorithmic. In general, disk layout tuning provides small performance benefits -- though there are exceptions if the tuning can relieve contention between, for example, two large, randomly accessed tables. Yours, Jonathan Leffler (johnl@osprey) >From: dave@columbo (Dave McCreery) >Date: 26 Oct 1995 16:01:38 GMT >X-Informix-List-Id: <news.18275> > >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. >============================================================================