Re: Tech Tip du Jour: Over the threshold

Neil Truby said: > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message > news:mailman.1454.1217725051.20610.informix-list@iiug.org... > >>> I suspect I'm setting myself up for a huge caning from John Miller III >>> here, but what the hell: > http://obotheclown.blogspot.com/2008/08/tech-tip-du-jour-sacred-mysteries-of.html > > Good article. But ... > >>> The reason it causes so much grief is often down to an application >>> design >>> issue: if you have one or more tables where index entries are >>> frequently >>> deleted, then the B-Tree cleaner process has an abnormal amount of work >>> to do. > > This is a piece of spin worthy of "New" Labour themselves! > In what way are the performance issues that caused by the way in which the > B-tree cleaner works by default, and which can only be altered by the DBA, > an "application design issue"? Well, there are often other ways that I could approach the problem of managing a queue than creating a highly active, over-indexed table. But, er, hey! What do I know? :o) -- Bye now, Obnoxio http://obotheclown.blogspot.com/