Skip to main content
Answer

Performance Issue on Generic Inquiry

  • December 27, 2023
  • 4 replies
  • 106 views

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

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. 

4 replies

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

@ngerst  Unable to verify this GI.

 


ngerst
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • December 27, 2023

@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
  • January 18, 2024

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


ngerst
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • Answer
  • January 19, 2024

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.