Re: Memory Requirements

One very large table and one user hmm .... SHMVIRTSIZE 2000 SHMADD 2000 buffers is more tricky , a minimal amount will be ok to work let say 1000. So the basic min would add up to about 6 megs, but giving more buffers will make the cache better, then again the table is so big that this may not help. It all depends how it will be used. Ing.Michael Asteriou <m.asteriou@magnet.at> wrote in article <01bc1348$5371c7f0$d51276c2@pcmias>... > Hi there, > > suppose having a database, consisting mainly of one very huge table where > the database size is between 8GB and 10GB. There is only one user (an > application acting as client to the database, as server to Window-clients). > Which memory size do I have to specify for the database-server (unix)..? > > thanks in advance > > :) mike > -- > +------------------------------------------+ > | brain at work | > | consulting - training - support | > | ing.michael asteriou | > | m.asteriou@magnet.at | > | http://members.magnet.at/m.asteriou | > | mobil:+43(0) 664-3086654 | > | tel:+43(0) 2269-2146 | > +------------------------------------------+ >