performans issue in dql and webtop

hi all.i have a jsp which lists(with datagrid) broken down workitems.in that list there is a column which is to show if an attachment of the workitem is locked or not.if it is locked there exists docbaselockicon in the column.

i determine locked attachment in this way:

IDfCollection coll = getQuery("SELECT r_lock_owner FROM dbo.hlk_document_sp where r_lock_owner!='' and workflow_id='"
      + oWorkitem.getWorkflowId().toString() + "'");
    if (coll.next()) {
          isLocked[i] = true;

} else {
isLocked[i] = false;

}

this work very slowly.what can i do to make performance better.(about the dql ).is there a caching system for this?

Best Regards.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

bacham2

If I understand your code correctly, you are performing this query for each item in the list. That is probably the cause of the slowness. No caching will improve this. Try to retrieve this information in a single query using a custom data handler for example.

All comments

Julien.Fontaine

Try to replace "SELECT r_lock_owner FROM dbo.hlk_document_sp where r_lock_owner!=''" by SELECT r_lock_owner FROM dbo.hlk_document_sp where r_lock_owner is not nullstring.

bacham2

ihsankocak

thank you for your solution but, the query is just for determining if the attachment of workitem is locked or not.in jsp i render the datagrid :

<dmf:datagridRowTd nowrap="true" cssclass="doclistlocicon">

<dmfx:docbaselockicon visible="<%=String.valueOf(form.isLocked[i]) %>" datafield="r_object_id" size='16' />

</dmf:datagridRowTd>

so, the query is not to render columns of it but to determine ifthe lock icon would be visible or not.

is it still ok to think about custom data handler?

Best Regards.

bacham2

Absolutely! If you launch a query for every item in a list view, it will take a long time to display even if the query returns in less than 100 ms. Just do the math: multiply the number of items on your page with the duration of the query, and you have a response time of sereval seconds (especially if you have 100 items per page).

ihsankocak

thank you for the replies.i figured out what was going on.this query executes in the onControlInitialized method which is called for all controls.for just 1 click this method has been called 1281 times.i removed the query to the init method of the component and it became fast.