Does it become necessary to create a filer routine at some point in the definition of a table? Or is it purely an efficiency mechanism? I have seen that filer routines handle index maintenance and so need to be recompiled after changing index definitions, but are there other table changes that would also require a recompile? And finally, when a filer routine is recompiled, do the M server processes need to be restarted in order to link to the new object code?
Ed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For a simple table, you do not need a filer. However, if you have indexes, as you noticed, a filer is necessary to manage the maintenance of the index. Additionally, if you have triggers, journals, or foreign key definitions, or have memo or blob columns in the table, then you need a filer to deal with those. Modifying any of these requires a recompilation of the filer.
And, yes, in general, any change to any routine that is being used by a server requires that you either stop and restart the server, or, you can make use of the function LINK^PBSUTL to add a routine to a list to be re-linked by active servers.
Dan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Does it become necessary to create a filer routine at some point in the definition of a table? Or is it purely an efficiency mechanism? I have seen that filer routines handle index maintenance and so need to be recompiled after changing index definitions, but are there other table changes that would also require a recompile? And finally, when a filer routine is recompiled, do the M server processes need to be restarted in order to link to the new object code?
Ed
For a simple table, you do not need a filer. However, if you have indexes, as you noticed, a filer is necessary to manage the maintenance of the index. Additionally, if you have triggers, journals, or foreign key definitions, or have memo or blob columns in the table, then you need a filer to deal with those. Modifying any of these requires a recompilation of the filer.
And, yes, in general, any change to any routine that is being used by a server requires that you either stop and restart the server, or, you can make use of the function LINK^PBSUTL to add a routine to a list to be re-linked by active servers.
Dan