Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
7 subscribers
Views
1268 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi All, We are running a series of Query Databases, where in which the exec
harshav
over 8 years ago
Hi All,
We are running a series of Query Databases, where in which the execution time for each query DB node is taking nearly 0.6 to 0.8 seconds. we have almost 7 query DBs to be written in a Process model and altogether it is giving the Output for us in 6 seconds. Still there is a need for us to optimize the Time, and also note that, there is no point in running the DB nodes parallel as there are interlinked.
Can someone explain us like what exactly is happening at the backend when a DB call is made from Appian using Query DB smart service. and what will happen if we are doing with Query Entity.(we are using both).
OriginalPostID-211733
OriginalPostID-211733
Discussion posts and replies are publicly visible
Parents
0
Eduardo Fuentes
Appian Employee
over 8 years ago
For Write to DS and Query Rules the logs are:
forum.appian.com/.../Logging.html
For Query RDBMS the logging is enabled in appian_log4j.properties by EDITING these properties and changing them from WARN to DEBUG
log4j.logger.com.appiancorp.process.runtime.activities.QueryRdbmsActivity=DEBUG
DEBUG
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Eduardo Fuentes
Appian Employee
over 8 years ago
For Write to DS and Query Rules the logs are:
forum.appian.com/.../Logging.html
For Query RDBMS the logging is enabled in appian_log4j.properties by EDITING these properties and changing them from WARN to DEBUG
log4j.logger.com.appiancorp.process.runtime.activities.QueryRdbmsActivity=DEBUG
DEBUG
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data