Forum Post: Improving The Performance Of Query

  • Thread starter Thread starter vignesh kumar
  • Start date Start date
Status
Not open for further replies.
V

vignesh kumar

Guest
Hi all, I need to improve the performance of query because it takes more time for the drop down list to appear. Lock should be shared-lock only by changing no-lock its improving but it should be in shared-lock only. Below is the query: FOR EACH xmm012 BREAK BY curcod BY effdat: IF LAST-of(curcod) AND LAST-OF(effdat) THEN DO: CREATE wxmm012. ASSIGN wxmm012.curcod = xmm012.curcod wxmm012.curdec = xmm012.curdec wxmm012.effdat = xmm012.effdat wxmm012.curd_t = xmm012.curd_t wxmm012.rate = xmm012.rate. END. END. Any suggestions friends?

Continue reading...
 
Status
Not open for further replies.
Back
Top