AW: Cache Size

Hello!

Thanx for the quick answer.

HOW does it depend on MAXUSERS. Right now I have setup around 217000 pages,
which is around 1,7 GB. I've set the /3GB-Flag in the boot.ini for my
Win2K-System, so that the application can access 3 GB, but anyway I can't
set a higher Cachesize above the 2GB.

For this reason it would be great to learn how MAXUSERS influences the
CACHE_SIZE.

Thanx a lot!

Chris

-----Ursprüngliche Nachricht-----
Von: "Döhr, Markus ICC-H" [mailto:Markus.Doehr@xxxxxxxxxxxxxxxxx]
Gesendet: Mittwoch, 23. Februar 2005 13:16
An: Christoph Weser; 'maxdb (E-Mail)'
Betreff: RE: Cache Size


> Are there any limits (min. and max.) of the parameter 
> CACHE_SIZE? Couldn#t find anything in the manual.

It depends on the operating system. If you're using a 32bit OS the max.
CACHE_SIZE is about 200.000 pages, depending on how high MAXUSERS is
defined. On a 64bit it's kind of "unlimited" - just limited by the available
memory.


SIEGENIA-AUBI KG
Informationswesen
 
i.A.
 
Markus Döhr
SAP-CC/BC, SAPDB-DBA

Tel.:    +49 6503 917-152
Fax:     +49 6503 917-7152
E-Mail: markus.doehr@xxxxxxxxxxxxxxxxx
Internet: http://www.siegenia-aubi.com 
  

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx