On Mon, May 22, 2006 at 05:55:16PM -0700, Joshua D. Drake wrote: > > >The reason the default is currently 10 is just conservatism: it was > >already an order of magnitude better than what it replaced (a *single* > >representative value) and I didn't feel I had the evidence to justify > >higher values. It's become clear that the default ought to be higher, > >but I've still got no good fix on a more reasonable default. 100 might > >be too much, or then again maybe not. > > > > My hands on experience is that 10 is plenty except for the minority of > tables within a database. Those table can be accurately represented > using alter table without having to adjust the global. Ditto. > That being said, 10 is fairly small and I often find myself setting the > value to at least 250 just to keep it out of my way. And ditto (though I normally go for 100). Have you ever run into problems from setting this too high? -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
