dm_maniacs

* Measure performance before and after using the hint.
* Turn on SQL tracing on the server. This will write the underlying SQL queries to the trace log which may then enable you to debug problems.
* Check “Show the SQL” in the DQL utility. This will also help you view the underlying SQL queriesRead more…

The attached fixml sizing program can be used to estimate the size of a Fulltext Index. Please only use this program in conjunction with the Sizing Documentum 5.3 Full Text white paper available on Powerlink.

OK you’ve created a custom object type, now its time to load it with templates!

The simple and quick way to do would be creating a new folder , lets say ‘<custom-obj-type>_template’ , under the cabinet ‘Templates’. You can either copy the objects you wish under /Templates and place them into the new folder you created, or you may do it for all objects via the ‘Add to Clipboard’. You can choose whichever way you’re comfortable.Read more…

1. API collections are used to loop through a set of object instances. While the collections are open, database cursors are open and thus locks are held in the database. Therefore, do not keep the collections open longer than necessary so that the cursors and locks will be released. Do not perform any extraneous operations within a collection that could be performed after or before the collection is opened. Consider retrieving and storing attributes being returned in a collection in local variables or an array first, and then processing them later in order to close the collection earlier. For example, an application may retrieve attributes within a collection and perform a “getfile” API (which could have a sizeable impact on elapsed time due to the transfer of the content) within the collection. It is best to store the attributes necessary to do the “getfile” in a local array, close the collection and then perform the “getfiles” afterwards, releasing the locks on the database.Read more…