Re: How to determine number of freelists

2002-04-11 Thread Anjo Kolk
Paul, The number of freelists should be a prime number that is equal or just less than the number of concurrent processes inserting. Anjo. Paul Baumgartel wrote: > Hi, all. Now that I know that I must increase freelists for my tables > with heavy insert activity, does anyone have a method f

How to determine number of freelists

2002-04-11 Thread Paul Baumgartel
Hi, all. Now that I know that I must increase freelists for my tables with heavy insert activity, does anyone have a method for determining just how many freelists the tables should have? So far, I haven't found anything in either TFM or the Net other than "increase the number of freelists". Th