A Performance Tips and Tricks

The following are some of the factors that affect the performance of Oracle Discussions Web Services:

• All the bulk operations in the Web Service interfaces take more time because they have to create or retrieve bulk data.

• Search is slower if the number of topics in a container is extremely large. It also takes more time if the wild card search criterion is given or if the search scope is for entire Oracle Discussions.

• All the listing processes of the containers, categories and forums will take more time if the call is invoked on the root of Oracle Discussions (container id is -1 and control parameter as * ).

• Listing the topics of a forum might take more time if the number of topics is very large in a forum.

• Listing of messages in a topic takes more time if the topic has large number of replies.

• In invoking bulk operations, users might experience client socket timeout exception. In the case of all create/update/delete operations (data definition, data manipulation) statements, though the socket times out, the operations will go through, unless there is an error in user input data. But in case of list/get operations (all retrieval operations), the user will not have a way of retrieving the data and he will have to narrow down/refine the query and fire it again.

  In create or update or delete operations, if there is an exception and the socket times out, the user will not be notified. It is planned to include notifications for bulk operations in next version.