Forum Discussion

walkerline117's avatar
walkerline117
Contributor
9 years ago
Solved

How the database excute works to have the best performance?Tips?

Hi, I am using Oracle/SQL execute snaps a lot to run some complicated queries. Can someone explain to me: In my case, my query would return 100000+ documents/rows, what I found is that durin...
  • cstewart's avatar
    cstewart
    9 years ago

    Are the downstream Snaps causing back-pressure? When it is running in that state producing 6 docs/sec, what are the input/output numbers on those downstream snaps?
    One quick way to establish if it is the Execute Snap causing the issue is to just run that Snap (disconnect the downstream ones, and see how it preforms.

cstewart's avatar
cstewart
Former Employee
9 years ago

Are the downstream Snaps causing back-pressure? When it is running in that state producing 6 docs/sec, what are the input/output numbers on those downstream snaps?
One quick way to establish if it is the Execute Snap causing the issue is to just run that Snap (disconnect the downstream ones, and see how it preforms.

  • walkerline117's avatar
    walkerline117
    Contributor
    9 years ago

    Yes, the downstream has a lot of pressue, you got it.

    And we have removed the pressure and now the database query snap goes fast.