: 43 : 43 : 0 |
As you know, the UNK table is an internal table in a Notes database that lists all the fields (in forms, subforms and shared fields) plus all items that exist in documents. This table tends to get very big for larger databases that are being touched by designers over the years. A spelling mistake for a field name will mean the field name is stored in the UNK table - for ever.
There are ways to get rid of those un-used table items by using compact in combination with full-text index handling.
But really, this should be a server task that runs automatically on the server.
An alternative to the server doing the update of the UNK table would be to have a button in the database properties dialog, similar to the 'compact' button.
And, as yet another alternative, this should be possible to do programmatically.
Even using the C API, this is extremely tricky as all you can do with the C API is to read the table - not actually modify the table.
|