O7:Removing indexes

[Mischa]

Hi Daniel,

I have a DataTool that recreates the db so that each record has the same RSN as before hence no file connect gets broken

Best greetings
Mischa.

-----Ursprüngliche Nachricht-----
Von: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] Im Auftrag von Daniel Sananes
Gesendet: Samstag, 24. August 2019 21:01
An: OmnisDev List - English
Betreff: SV: O7:Removing indexes

Hi Doug
Good point keeping indexes for easier recovery.
This has led me to keep 2 indexes in orderrows and invoicerows. These two indexes keep the order-/invoice-head number and the number for the connected client.
Removing the other 6 indexes gives me about 4 million unused blocks instead of 2 million blocks if not removing these indexes.
This is one reason for removing the indexes, the other reason is that these 6 indexes are stupid and has no importance whatsoever.

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 Doug Easterbrook
Skickat: den 23 augusti 2019 04:30
Till: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Ämne: Re: O7:Removing indexes

Hi Daniel

Brian (and others) make good points ….. particularly data recover

I’m going way back in time, but I recall that if we ever had issues with a file, one of the advantages of having extra indexes is that if one got corrupt, then you had a much better chance of retrieving your data by reading down another index.

There is the internal record seq (which we always made visible) ..  but if you couldn’t find data using that, or some other key….  You were sometimes hooped - you were on the path to losing data.   So another index sometimes helped find the missing data.


Just a fact of life with DF1’s.



If you are not running out of space the the primary segment (or all segments for that matter), the indexes are not really hurting, so why remove them.



Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On August 22, 2019, at 6: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

_____________________________________________________________
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