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
1265 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
0
PhilB
A Score Level 1
over 8 years ago
If you have access to the database, you should be able to switch on SQL logging to see the exact queries that are being run.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
Thanks for the input philb, May be I am not that much accurate in explaining the question, Let me put it in this way, I want to know what exactly is running in the backend in Appian, when I run the script ( Like the moment I execute the DB node and the data is fetched back to Appian what is going in the backend ), what is going on, not what is going on in the DB . Any inputs please.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 8 years ago
Ah ok!
As I understand it, Appian uses Hibernate (
http://hibernate.org/)
for the database access, so presumably it follows something along the lines of their documentation for an instance of Query entity. However, I believe the Query database node uses JDBC so is probably slightly difference.
I am only really guessing there through, so maybe someone else can give you more details!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jim Schweitzer
Certified Lead Developer
over 8 years ago
There is also logging that can be enabled in the appian side to show query details in the jboss logs. Don't have the actual setting off the top of my head.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
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
0
Eduardo Fuentes
Appian Employee
over 8 years ago
and
log4j.logger.com.appiancorp.process.runtime.activities.JdbcActivity=DEBUG
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel