Re: Can this be done?
Posted in 1994
In article <3adhaq$g49@gv-gate.gvg.tek.com>, martina@gvgtsg.gvg.tek.com (Martin Allred) wrote: > I was thinking, so look out. Can OnLine use a RAM-disk for the primary > database storage and put the mirror on a real disk? This should allow > for some serious speed improvements while keeping some integrity due > to the mirror of the database. > > If this is possible, can the read-from-both-copies-of-the-database > capability be turned off so reading is done only from RAM? > > Martin > > > -------------------------------------------------------------------------- > + Martin Allred "A little pain never hurt anyone." + > + Grass Valley Group /\\ /\\ + > + martina@gvgtsg.gvg.tek.com __/G \\/ G\\__ + Martin: If you have enough memory for a RAM disk, it may be easier (OnLine version 5) to configure a huge shared memory segment instead. Experiment with increasing the TBCONFIG parameters BUFFERS (25000), LRUS (32), and CKPTINTVL (3600). The thought here is to run primarily from cache as opposed to disk. tbstat -p should show you %cached above 95% for reads and writes, once you have the config down. -Charlie