Re: Managing different indexes for different databases

2018-12-14 Thread Tom Dillon via 4D_Tech
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

Re: Managing different indexes for different databases

2018-12-14 Thread Chip Scheide via 4D_Tech
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 +, 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

Managing different indexes for different databases

2018-12-14 Thread Pat Bensky via 4D_Tech
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