• State Suggested Answer
  • Replies 4 replies
  • Answers 2 answers
  • Subscribers 13 subscribers
  • Views 10644 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Best Practices

use of function executestoredprocedure()

sahilb346

Hello All,

we are using 4 record in 1site and for every record summary screen awe are having a common interface.

We are using function executestoredprocedure() to get the data for the summary screen and

the store procedure is giving the output from 11 tables for just one id.

and we are getting performance issues. My concern is that using of function executestoredprocedure() is affecting it.

and what is the other substitute we can use in place of executestoredprocedure().

 

Thanks In Advance

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    The function itself is pretty lightweight and using standard the Java/JDBC drivers to connect. In my experience, any issues with performance tend to be with the stored procedure itself. There aren't other SP functions available in the field to my knowledge, and this is the one I've personally used on many different engagements. As for alternatives, we'd have to understand more about your data structure and what you are trying to now what else might be feasible.

    Regardless, can you clarify what you mean by performance issues? What have you investigated that points you in the direction of the executestoredprocedure function as the issue? If you haven't already, I would look into expression detail logs and performance view for your interfaces, and get timing on that function versus overall interface load time.
Reply
  • 0
    Certified Lead Developer
    The function itself is pretty lightweight and using standard the Java/JDBC drivers to connect. In my experience, any issues with performance tend to be with the stored procedure itself. There aren't other SP functions available in the field to my knowledge, and this is the one I've personally used on many different engagements. As for alternatives, we'd have to understand more about your data structure and what you are trying to now what else might be feasible.

    Regardless, can you clarify what you mean by performance issues? What have you investigated that points you in the direction of the executestoredprocedure function as the issue? If you haven't already, I would look into expression detail logs and performance view for your interfaces, and get timing on that function versus overall interface load time.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.