SV: O7:Removing indexes

[Daniel Sananes]

Hi Grant
As said in answer to Doug there are some indexes that do not make any sense keeping.
We do automatically backups every night and yes I have tested and everything works OK.
One has to reorganize data of course when these kind of changes are done.
As my experience is that just removing indexes, and adding a new one that I find necessary, will result in corrupted data that may or may not be repaired by Omnis Check data.
Therefore I do it in two steps.
Step 1, remove all indexes and reorganize.
Step 2, add the indexes you want to keep and reorganize again.
This way it seems Omnis will not give you any notification of corrupted that has to be repaired.

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 Grant Thiessen bookitinc
Skickat: den 23 augusti 2019 01:50
Till: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Ämne: Re: O7:Removing indexes

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 



_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com