P
Paul Koufalis
Guest
Hi, First, it is always a good idea to tell us about your environment when posing such questions. What version of Progress? How many concurrent users? How big are the databases? What kind of application: ERP? WMS? CRM? There is no such calculation as it is completely application dependent. You could have a 10 concurrent user system that reads and locks millions of rows or a 1000 concurrent user system that reads and lock millions of rows. 100K is a good round number for -L. On modern versions of Progress I believe each lock-table entry consumes less than 100 bytes, so that's no more than 10 Mg of memory. For -B, you'll find a lot of articles saying "10% of your DB size". Since we have ZERO information about your site, start there and monitor your hit ratio. One important note though: a small increase in hit ratio requires a LARGE increase in -B. If you start at 10% of DB size and see your buffer hit ratio is 95%, double the -B value if possible.
Continue reading...
Continue reading...