Skip to main content
Solved

Performance Issue on Generic Inquiry


ngerst
Freshman II
Forum|alt.badge.img

I have a slight performance issue on the Generic Inquiry I am running. The inquiry is looking at expediate/priority jobs for my organization but the way I am doing it, it seems to cause a performance issue for on the database. At this time it’s nothing major but I would like to improve it so as the organization grows it doesn’t become a larger burden. 

 

Attached is the XML of the Generic Inquiry, any advice would be helpful!

Best answer by ngerst

Chris Hackett wrote:

Hi @ngerst were you able to find a solution? Thank you!

Yes I was able to work through a solution to pull in our custom items. 

View original
Did this topic help you find an answer to your question?

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3417 replies
  • December 27, 2023

@ngerst  Unable to verify this GI.

 


ngerst
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • 37 replies
  • December 27, 2023
Naveen Boga wrote:

@ngerst  Unable to verify this GI.

 I believe these are custom tables/views I was trying to see if there is any other way to have pull the data they need in a more efficient way. I am a new user to Acumatica and working through the tables trying to determine the best joins we can have. 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2810 replies
  • January 18, 2024

Hi @ngerst were you able to find a solution? Thank you!


ngerst
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • 37 replies
  • Answer
  • January 19, 2024
Chris Hackett wrote:

Hi @ngerst were you able to find a solution? Thank you!

Yes I was able to work through a solution to pull in our custom items. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings