Subject: O7:Removing indexes

[Bryan Brodie]

Hi Daniel,

I believe that if you go to each File definition window in O7, there is a
button at the bottom of the screen for displaying all the indexed fields.
Sometimes developers have concatenated or otherwise combined indexes in
tricky ways. So I would proceed carefully.

I would note each indexed field name in every file format that uses them,
and then use the FIND ALL search to look for those field names. This should
give you some context regarding how the indexes were intended to be
utilized. If the application was originally designed by someone who did not
understand indexed fields, they may have just indexed everything.

Another important element to consider is the eventual need to completely
rebuild the DF file from scratch using exported and re-imported data.

All sequence numbers will be recalculated during an import, so depending on
how you export-import your data, all those file connections will be broken.
(This is why I stopped using connected files many years ago - they
dramatically complicate data file rebuild and recovery from errors).

If you don't maintain another way to preserve and reconnect the connections
between files during an Omnis 7 DF file export-import-rebuild, the database
will be essentially trashed.

And, if you need to export your legacy DF file to ASCII in preparation for
import into SQL, you are going to have to manage all those Omnis
connections as record keys in SQL.

Even if you're migrating O7 to Studio 8 or 10 and thinking to switch to
SQL, the file fields can be handy for populating windows, reports etc and
preserving / reusing program logic.

MacOS no longer supports multi-user DF file access as of Omnis Studio 8.

Feel free to reach out on or off list with DF file format questions - I
have a lot of experience with this (since 1985).

Bryan Brodie

From: Daniel Sananes <daniel.s at kopparbergs.se>
> To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
> Subject: SV: O7:Removing indexes
>
> 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
>

-- 
Bryan Brodie
Appimatic LLC
804-591-0947