Openedge queryhandle:QUERY-OPEN is slow

Posted by saquib on 06-Sep-2012 09:49


I have a dynamic query with around 8 buffers and I've noticed that the QUERY-OPEN statement is slow. It's taking around 330 milliseconds to perform this action.

Is this normal? If not, what should I be looking at to try to resolve the issue?



All Replies

Posted by Peter Judge on 06-Sep-2012 09:52

Is the same query slow when you make it a static query or a for each? If so, then look at the usual query suspects: indexing etc.

-- peter

This thread is closed