SV: Subject: O7:Removing indexes

[Daniel Sananes]

Hi Bryan
This previous developer has not used the possibility with concatenated indexes.
And I think he indexed much more than necessary. Why index the field that saves the 10 orderrows number from 1 to 10 for instance?
I have done a Find all for every index in our mayor library and in 3 minor libraries that depend on the mayor.
When it comes to export/import of these datafiles that use connected files I have built a tool that takes care of this pretty nice.
Instead of first manually import the parent and then import the child with a non Sequence field like Orderno. I press a button and it is done automatically with only a few manual interventions.
This had to be done a couple of times due to datafiles being full and also for a some datacrash we had.
---
Essentially, I am trying to bring our datafiles into a state of no connected files so that the migration to SQL is done much easier.
Soon, puh…,  the native commands of reading data will be replaced with SQL.
---
I will certainly reach out later on when this transition starts. I am a bit unsure how to manage this transition.
I am thinking a complete rewrite can be done in Studio. Would not take that long really.
An important step is however, as you mentioned, to export all existing data and populate an SQL-database.

hälsning
Daniel Sananés
Kopparbergs Bryggeri AB
Tel:  + 46 (0)736 70 40 70

Från: Bryan Brodie <brb at appimatic.com>
Skickat: den 23 augusti 2019 03:53
Till: Daniel Sananes <daniel.s at kopparbergs.se>
Kopia: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Ämne: Re: Subject: O7:Removing indexes

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<mailto:daniel.s at kopparbergs.se>>
To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com<mailto: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<mailto: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<mailto: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
[https://www.livhelp.com/img/post/sig-hands.png]