Re: Tech Tip Du Jour

Posted in 2008

TBP — Fri, 18 Jul 2008 09:37:26 +0100 — source: Usenet: comp.databases.informix

Art Kagel wrote: > Potato: > > In your case I might go all the way and configure ALICE mode. It will > do MUCH more to reduce the work that the BTSCANNERS have to do on larger > indexes than even Range Scanning which you are planning to configure. > Take you config and add alice=12 to it. You are correct, the defaults > are only practical for very small databases and ones that do few large > deletes. Download the BTSCANNER presentation given at IIUG this year. > It was very good. > > Art > If you mean this one : http://www.iiug.org/calendar/conf/cpc/slides_dvd/DVD/D14_Jamison_ALICE_and_Other_BTSCANNER_Tips.pdf I am struggling to get it :-/ Even logged in etc. etc.

↪ replying to TBP

Art Kagel — Fri, 18 Jul 2008 17:35:55 -0400 — source: Usenet: comp.databases.informix

Got the presentations loaded onto the Oninit Web site now as well. Go to: http://presentations.oninit.com/public/2008IIUG/D14_Jamison_ALICE_and_Other_BTSCANNER_Tips.pdf For the BTScanner presentation. Art On Fri, Jul 18, 2008 at 4:37 AM, TBP <theBP@usenet-news.net> wrote: > Art Kagel wrote: > > Potato: > > > > In your case I might go all the way and configure ALICE mode. It will > > do MUCH more to reduce the work that the BTSCANNERS have to do on larger > > indexes than even Range Scanning which you are planning to configure. > > Take you config and add alice=12 to it. You are correct, the defaults > > are only practical for very small databases and ones that do few large > > deletes. Download the BTSCANNER presentation given at IIUG this year. > > It was very good. > > > > Art > > > > If you mean this one : > > > http://www.iiug.org/calendar/conf/cpc/slides_dvd/DVD/D14_Jamison_ALICE_and_Other_BTSCANNER_Tips.pdf > > I am struggling to get it :-/ > > Even logged in etc. etc. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.