O7:Removing indexes

[Grant Thiessen bookitinc]

Find first on Indexed Field

If you don’t have indexed fields, finding a particular record may involve reading all of the records in that file format.  If you have a lot of records, you may experience a considerable slowdown in performance.

Personally, I would make a backup of the data file, then remove the indexed fields, then see if everything works OK.  If things work OK, and you don’t experience a slowdown in retrieving data, you are good to go.  If not, replace the data file from your backup.

Grant
> On 08-22-2019, at 8:24 AM, Daniel Sananes <daniel.s at kopparbergs.se> wrote:
> 
> Hi Kelly
> I don't think the fields in the Sort of a report has to be indexed.
> But a field in a window or report that use the Autofind has to be indexed.  Another thing to check.
> 
> regards 
> Daniel Sananés
> Kopparbergs Bryggeri AB
> Tel:  + 46 (0)736 70 40 70
> 
> -----Ursprungligt meddelande-----
> Från: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> För Kelly Burgess
> Skickat: den 22 augusti 2019 13:26
> Till: OmnisList <omnisdev-en at lists.omnis-dev.com>
> Ämne: Re: O7:Removing indexes
> 
> Hi Daniel,
> 
>> Single file find on IndexedField
>> Find on IndexedField
>> Build list from file on IndexedField
>> Next and Previous on IndexedField
>> 
>> Where I cannot find any IndexedFields must mean I can remove the indexes in the fileformat.
>> Or do I have to think about something else
> 
> Check your reports' use of sort fields.
> 
> Kelly
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 


Grant Thiessen

google:     bookitinc
email:        bookit at bookitinc.com
facebook:  J. Grant Thiessen

BookIT Enterprises Ltd.
15 Georgetown Drive
Winnipeg, MB  R3Y 1R8
Canada

To unsubscribe from all PROMOTIONAL messages from BookIT Enterprises Inc., click unsubscribe at bookitinc.com.  You will continue to receive notifications consisting of factual information about your account and purchases, and responses to direct requests for information.


We'd love to stay in touch.  If you would like to receive announcements of future new acquisitions or special sales, click opt-in at bookitinc.com