turn the indexes on the customer tables OFF? for development - indexed or not should not matter signifcantly.
Chip On Fri, 14 Dec 2018 14:25:08 +0000, 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 > > -- > ************************************************* > 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:[email protected] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
