Hi Tom, There are 100 customer-definable data tables and each has over 500 fields. Any of these fields could be indexed. So it would not be practical to index all the optional fields!
Pat On Fri, 14 Dec 2018 at 15:30, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> wrote: > Pat, > > Now you've got me intrigued. Not to question the validity of this at all, > but what does this do for the customer that leaving all the optional > indexes on would? > > Do you, from the design mode, have all the optional indexes turned on, and > turn off indexes based on the FieldMap settings? If so, if the Designer > logged in would skipping the code that turns off these indexes allow a > developer to work without it reindexing? Or, similarly, if a file called > "Don't Reindex!" exists on the development machine, don't reset the indexes? > > > > Pat Bensky via 4D_Tech wrote: > > >In our app (CatBase) each customer can manage their own tables and fields > >and one of the things they can do is specify whether a particular field is > >indexed. Since these indexes are different for each customer, when they > get > >a program update from us, the indexes have to be recreated and built > (there > >is a FieldMap table which stores each field's attributes). This is n't a > >problem for our customers, but for us developers, it means that if we are > >working on several projects, each time we switch from one customer's > >database to another, the indexes are all rebuilt. One project I'm > currently > >working on has about 4 million records and it takes ages to rebuild all > the > >indexes! The only way around it as far as I can see is to keep two copies > >of the structure - one to use just with that database and one for all the > >others. But that would introduce all kinds of possibilities for error ... > > > >Anybody got a better idea for managing this? > > > >Pat > > -- > ------------------------------------------------------------------ > Tom Dillon 375 S Main St #405 > DataCraft Moab, UT 84532 > tomdil...@datacraft-inc.com 720/209-6502 > ------------------------------------------------------------------ > Only the turtle strong enough to dig itself out of its sandy > birthplace makes it to the sea to become a snack for the > waiting barracuda. --- Sunastar > ------------------------------------------------------------------ > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** -- ************************************************* CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
