Dependent Lookup Select Box Causing Slowdowns

[Erik Nelson]

Hello,

I have an issue that I'm fairly certain I've narrowed down to a dependent Lookup Select Box variable where the catalog item using it, not only takes upwards of a minute to load, but the task generated takes long enough to load that it routinely times out. The current setup is using a Lookup Select to Incident>Category as the dependent value with the dependent variable looking at the Choice [sys_choice] table for the subcategories. I've done a complete rebuild, with what should be a cleaner reference directly to Incidenr>Subcategory, but even that appears to be slowing load time of the Catalog Item (still around 30 seconds).

I have another setup like this on a different catalog item (using the cmdb_ci table) and it doesn't have any issues with response time.

Has anyone seen this type of issue before, and if so, how did you resolve it?

Thanks

Erik

[Brad Bowman · Accepted solution]

Hi Erik,

Can you clarify your setup of the category and subcategory variables?  Are you using the choice table for both?  A lookup on the incident table will slow down as the number of incident records increases.  I have a setup like this that runs pretty smoothly.

[Erik Nelson]

Thanks Brad, that totally took care of the delays on the item load and explains why there were delays. I'd initially gone to sys_choice on the rebuild but missed a piece of the reference qualifier which took me back to incident for both.

Erik