Querying "select b.* from KUAFChildren..." puts a load on the database

Ivan Kolchenko · 2024-03-20T12:46:01+00:00

There was an error rendering this rich post.

Good afternoon experts!
The following query is executed on the production database:

select b.* from KUAFChildren a, KUAF b where a.ID=:A1 and a.ChildID=b.ID

It is performed frequently and gives a significant load.
Can anyone explain what kind of request this is and why, is it possible to change its execution frequency or disable it completely?
Thanks a lot for any help!

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

appuq

What I would do is instead of trying to find the IP of OT, sign an NDA and they will send you the schema document.KUAF has a user or Group, KUAFchildren lists the number of records for a given ID

Why does it have to do it obviously permissions if Groups, Roles etc are done in a very bad way then the system is trying to figure out if the loggedin user has access to ceratin objects in CS.

All comments

appuq

What I would do is instead of trying to find the IP of OT, sign an NDA and they will send you the schema document.KUAF has a user or Group, KUAFchildren lists the number of records for a given ID

Why does it have to do it obviously permissions if Groups, Roles etc are done in a very bad way then the system is trying to figure out if the loggedin user has access to ceratin objects in CS.

Greg Griffiths

your DBA should also be able to advise on the correct setup of Index use etc to improve the performance of the query in your database.

Ivan Kolchenko

Hi,

Thanks for the clarification, it helped me a lot.