Re: CACHE BUFFERS

Billy Wheeler wrote: > > Kevin, > > There is no reason to have a large number of UNIX kernel buffers if you're > using OnLine. I assume it's V*d*c. The only reason you would want many > buffers is if you were doing lots of file system access. Wellll, not exactly. OK, since it's SCO, there are still alot of tuneable kernel parameters that you might want to tweek. (HP / IBM have reduced theirs.) By increasing the number of buffers within the kernel, you are also increasing the size of the kernel. Which is a negative. On the positive side, by increasing the number of buffers you increase the performace of the file system. (Which is what Billy said.) If you are running ONLINE and are using cooked chunks, then your performance will be affected. If you set your DBTEMPSPACE , (OR is it DBTEMP?), to a UNIX filesystem, you will see some improvement in performance. Before anyone asks, "Well gee why would I want to do that?", If you have your Database on a separate DASD and Controllers, and the machine is mainly used as a database engine, moving the temp stuff to a different controller and disk will improve performance and load balancing. Of course, if you forgot to include temp space requirements when sizing your database, you may not have room on your Database Disks. -Just my .02 worth. Mikey