I want to know, what to expect, when a server with Psql v8 has 2 GBs of RAM and I give 4 GBs more. Will it be faster or not? Is it worth to give 8 GBs of RAM? I could not find any info about it on the Pervasive site.
Just putting in an extra 4GB may or may not help. There are more factors than just the amount of RAM. For example, if you are connecting through a slow network link, the amount of RAM won't help. Also, if the performance limiting factor is not RAM or CPU but a slow hard drive then RAM won't help.
You need to determine where the performance bottleneck is before you try to address it.
Are you seeing some specific performance problem that you're trying to address?
Have you contacted the vendor of the application to find out what they recommend for Pervasive settings to optimize performance?
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Yes, the bottleneck is the disk I/O, it seems. But what to do, it is already in RAID10 15k disks. I could add some more spindles.
The vendor is just testing the app for performance. First we should go to v8 from 2000i SP4. Then convert the dbs from v5 to v8. If the db is compact, disk I/O-s should be less.
Then comes the memory question. 2000i can use only 640 MB for cache. v8 can use the whole preset %. Is this dynamic cache that intelligent, that if I give 4 GB more then it can cache the most used db pieces for read/write, and therefore reduces that much disk I/O?
The question is that from the nearly 500 smaller db files and 1 5,5 GB, 1 4 GB, 2 2,5 GB, 1 2 GB dbs (in 2 GB chunks) could it put it in the dynamic cache and runs the server almost from RAM?
How can I test it out, how much memory could it effectively use?