Omnis 7 Datafile Segmentation

[Marc De Roover]

Martin,


Doug’s solution is simple en super efficient, we have been managing 
our DF’s for several years like this.

Our application uses 5 datafiles ( all with multiple segments ), we even 
have a  DataFile which contains only a single file and which expands 
over 14 segments.

Our experience is also that this approach reduced significantly the risk 
of DF corruption and optimised data acces performance. ( since the 
DF’s are not auto expanding, the datafile is created “neatly” and 
the data is not “all over the place” on the HDD ).

Always welcome for additional info

Regards,



Marc


On 25 Jan 2023, at 16:52, Doug Easterbrook via omnisdev-en wrote:

> here’s a link to what we used for years with omnis 7 to detect and 
> expand a database.
>
>
> http://www2.artsman.com/omnis/Software/ExpandDB.zip 
> <http://www2.artsman.com/omnis/Software/ExpandDB.zip>
>
>
>
> for what its worth, we had two main data files in our application, 
> both of which could be expanded to 15 segments.
>
>
> The key to using multiple segments is to
> 1) make a main segment at the start of the process.. that is small
> 2) add a second segment
>
> Omnis automaticall puts data into the other segments, since the main 
> one is small.
>
> so, as the second segment gets full, you would add a third segment to 
> let that fill up.
>
>
>
> this gives you leeway since only the first segment can be auto 
> expanding.   if you miss seeing that the second (or third) segment is 
> full, data goes into the first and does not hurt you.      gives you 
> time to make another segment .. which can only be done in single user 
> mode when one person is using the database.
>
>
>
> so, the example app detects those kinds of things.
>
>
> enjoy.
>
>
>
>
>
>
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
>
>> On Jan 25, 2023, at 1:47 AM, Martin Obongita via omnisdev-en 
>> <omnisdev-en at lists.omnis-dev.com> wrote:
>>
>> Hi All,
>> How do I detect that an Omnis DF1 file is full and needs to be 
>> segmented?
>> How do I segment the datafile programmatically without the need for 
>> user intervention?
>> I am using an Omnis classic library ver 8.3.1.
>> Kind regards
>> Martin Obongita
>> _____________________________________________________________
>> Manage your list subscriptions at https://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
ARC - your Apple service partner