VERSIONS: Paradox 5 and later
SUBJECT: BDE SETTINGS
BY: BRIAN BUSHAY
I would leave MAXFILEHANDLES at its default of 48.
Make sure MINBUFSIZE is at least 1 meg, 1024. Getting MINBUFSIZE to one meg is the only thing I have found that makes much
difference.
MAXBUFSIZE 8-16 meg, 8192 or 16384.
Here is general rule of thumb for MEMSIZE
- Take the total amount of RAM on the machine and subtract 16MB for NT or 8MB for Win95.
- With the remaining amount of RAM, set MEMSIZE to 3/4 of the amount and SHAREDMEMSIZE to 1/4 of the amount.
For example : If you had a 64MB machine running NT you would start with 48MB (64-16) and set :
MEMSIZE = 36 (48 * .75)
SHAREDMEMSIZE = 12288 (48 * .25)
Note MEMSIZE is in MB and SHAREDMEMSIZE is in KB.