O$: removing Slots before creating Datafile

Fred Brinkman fred.brinkman at euromnis.com
Thu Jan 21 08:36:55 EST 2010


I already understood that... ;-)


Fred Brinkman
www.euromnis.com

**********************************************
Fred Brinkman Consultancy
B-1000 Brussels

Tel. +32-474-83 80 80
Fax +32-2-330 10 31 (on request)
Email fred.brinkman at euromnis.com
*********************************************











Op 21 jan 2010, om 14:33 heeft Nick Renders het volgende geschreven:

> Oops, I meant: the first segment should be 50 blocks or 32 KB.
>
>
> On 21 Jan 2010, at 13:55, Nick Renders wrote:
>
>> Hi Fred,
>>
>> I have noticed that these empty slots actually do take up space. I  
>> want to create Datafiles with the first segment as small as  
>> possible (50 segments, which means about 32 KB disk space). But  
>> when I first do some inserts on another Datafile, the new Datafile  
>> will be larger in size (63 empty slots take up 570 block or 292 KB).
>>
>> Creating a Datafile in the Studio Browser has the exact same effect.
>>
>> Nick
>>
>>
>> On 21 Jan 2010, at 12:17, Fred Brinkman wrote:
>>
>>> Nick,
>>>
>>> In the browser you can go to the data slots and just delete the  
>>> empty ones. They will be recreated the moment a record is  
>>> inserted. Deleting the empty slots not do anything  much of  
>>> course, it does not create space (as they are empty) but it looks  
>>> cleaner...
>>>
>>> You could write a small method to do this cleaning on startup.
>>>
>>> Hth
>>>
>>> Fred
>>>
>>>
>>> Fred Brinkman
>>> www.euromnis.com
>>>
>>> **********************************************
>>> Fred Brinkman Consultancy
>>> B-1000 Brussels
>>>
>>> Tel. +32-474-83 80 80
>>> Fax +32-2-330 10 31 (on request)
>>> Email fred.brinkman at euromnis.com
>>> *********************************************
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Op 21 jan 2010, om 11:59 heeft Nick Renders het volgende geschreven:
>>>
>>>> Hello,
>>>>
>>>> When I do some DML stuff (find, insert, update, ...) in my  
>>>> Library and create a Datafile afterwards, that new Datafile will  
>>>> have emtpy Slots for the Files that I have used before. Is there  
>>>> a way to clear all this info, so that a new Datafile will have no  
>>>> Slots?
>>>>
>>>> I have tried "Clear all files", but that command doesn't have any  
>>>> impact on the Slot info. I guess I could delete the Slots after  
>>>> creating the Datafile, but that wouldn't clear the disk space,  
>>>> would it?
>>>>
>>>> This is how I create the Datafile:
>>>> Do $datas.$add(lPath,kTrue,lName,lErrorCode,lError) Returns  
>>>> rDataFile
>>>>
>>>>
>>>> Regards,
>>>>
>>>>
>>>> Nick Renders
>>>>
>>>> ARC - your ICT service partner
>>>> H. D. Saviolaan 8
>>>> 1700 Dilbeek
>>>> T: (00 32) (0)2 466 50 00
>>>> F: (00 32) (0)2 466 88 33
>>>> http://www.arcict.com
>>>>
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com




More information about the omnisdev-en mailing list