Focal Point
Load MF Focus DB

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1821081482

May 14, 2008, 09:45 PM
dz
Load MF Focus DB
I came across a Focus load program that loads a multi segment mainframe Focus DB. At the end of the load there is "table file" that counts all the segments in the new db. When I suggested to remove it, I was told that since this file has aditional "referrence" files it is necessry in "exclusive mode" to parse all the segments in order to populate adresses or pointers of the referrence dbs. If this is not perfromed the performance will be significantly slower. Is it true? If yes it is still valid today? Can someone explain this to me? This query is very cpu costly.
May 15, 2008, 02:41 AM
GamP
If the masterfile of the database contains references to segments outside of the database itself and if those references are static, then this method of tabling the file after creation or loading is indeed still valid.
A static join in the master file (segments with segtypes of Kx) will reserve a pointer in the database that will only be resolved using table.
If you do not resolve this pointer then this will be done when the record is referenced for the first time. So only the first usage will pay the performance price, after that the pointer will be used and it will be updated only if needed.
Depending on the size of the databases this can indeed be quite costly.

Hope this helps ...


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988