05 March 2008

Symptoms

How do I disable the creation of dmi_queue_items that relate to full text indexing? If you do not intend to use full text indexing in 5.3 or above, you will need to disable the creation of the queue items that are created automatically. If you do not do this, your dmi_queue_item can grow quite large and this can cause performance issues.

Resolution

To resolve this, you need to remove the registered events related to full text indexing from the docbase. Run the following DQL to find the events:

DQL
DQL> select * from dmi_registry where user_name = `dm_fulltext_index_user'

r_object_id user_name registered_id event
================ ========================== ============ =====

2600007b80000500 dm_fulltext_index_user 0300007b80000105 dm_save
2600007b80000501 dm_fulltext_index_user 0300007b80000105 dm_destroy
2600007b80000502 dm_fulltext_index_user 0300007b80000105 dm_readonlysave
2600007b80000503 dm_fulltext_index_user 0300007b80000105 dm_checkin
2600007b80000900 dm_fulltext_index_user 0300007b80000105 dm_move_content

Then you can use the unregister API to remove these events. The syntax is

API
API>unregister,c,,,

Using one of the results above, the API would look like this:

API
API>unregister,c,0300007b80000105,dm_save,dm_fulltext_index_user

Repeat this for the remaining events.

NOTE: You will need to manually delete the existing dmi_queue_items that have already been created.


Less Is More ~ Older posts are available in the archive.