• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Slow Performance on Complex SQL

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Slow Performance on Complex SQL

    I've been trying to improve performance on a couple of options where my data source uses pretty complex SQL. Running in Valence seems to take an age to load (maybe 30 seconds). If I run the same SQL in IBM navigator, I get a small overhead the first time I run the statement, but, thereafter, the SQL runs almost instantaneously. Are there any settings I can tweak to improve overall performance of these options?
    Tags: None
  • #2
    It might have something to do with the SQL sort sequence being used in NAB versus Navigator or ACS, particularly on larger tables. This blog post may have some useful info on that topic:

    Your users have a NEED for SPEED! | CNX Corp
    https://cnxcorp.com/tip-month/your-users-have-a-need-for-speed/
    Just about every modern office job involves users interacting with a computer for the bulk of their work day.  So excessive waiting for the computer to respond to actions can lead to both user frustration and decreased productivity.  In short, users like speed! A study published by Nielsen Norman Group at…

    Comment

    • #3
      I would recommend using the "Run and Explain" in ACS Run Sql Scripts... It will suggest indexes that you may want to build.

      Comment

      Previous template Next
      Working...
      X