When I click on Items in the GUI on a UNIX Host that has a template and approximately 120 items the database query hangs for a very long time (5 to 10 minutes) before returning the items for the host.
This is the only section of the GUI that seems to have any issues. The query hangs with status "Copying to tmp table" and here are two sample queries:
Has anyone had a problem like this?
w
This is the only section of the GUI that seems to have any issues. The query hangs with status "Copying to tmp table" and here are two sample queries:
Code:
ELECT DISTINCT a.*,ia.itemid FROM applications a,items_applications ia WHERE ((a.applicationid BETWEEN 000000000000000 AND 099999999999999)) AND (ia.itemid IN (60740,60739,60738,60737,60736,60735,60734,60733,60732,60731,60730,60729,60728,60727,60726,60725,60724,60723,60722,60721,60720,60719,60718,60717,60716,60715,60714,60713,60712,60711,60710,60709,60708,60707,60706,60705,60704,60703,60702,60701,60700,60699,60698,60697,60696,60695,60694,60693,60692,60691,60690,60689,60688,60687,60686,60685,60684,60683,60682,60681,60680,60679,60678,60677,60676,60675,60674,60673,60672,60671,60670,60669,60668,60667,60666,60665,60664,60663,60662,60661,60660,60659,60658,60657,60656,60655,60654,60653,60652,60651,60650,60649,60648,60647)) AND a.applicationid=ia.applicationid
Code:
SELECT DISTINCT a.*,ia.itemid FROM applications a,items_applications ia WHERE ((a.applicationid BETWEEN 000000000000000 AND 099999999999999)) AND (ia.itemid IN (48519,48518,48517,48516,48515,48514,48513,48512,48511,48510,48509,48508,48507,48506,48505,48504,48503,48502,48501,48500,48499,48497,48496,48495,48494,48493,48492,48491,48490,48489,48488,48487,316853,48486,48485,48484,48483,48482,48481,48480,48479,48478,48477,48476,48475,48474,48473,48472,48471,48470,48469,48468,48467,48466,48465,48464,48463,48462,48461,48460,48459,48458,48457,48456,48455,48454,48453,48452,48451,57915,57856,48450,48446,48445,48444,48443,48442,48441,48440,48439,48438,48437,48436,48435,48434,48433,48432,48431,48430,48429)) AND a.applicationid=ia.applicationid
w
Comment