"ADN Table Key Lookup" field takes too long

Luis Reis

Hello everyone
We have a problem with a TKL field that performs a simple select in the database.
It is taking 1 minute to load the data on the screen from the smart view, do you know of any way to improve the performance of loading the data from this field?

note: 37,000 records are loaded
this is the query
select Razao_Social as "Razão Social", CPF_CNPJ as "CPF/CNPJ" from CEDOC_Cliente
in the database it takes about 3 seconds

appuq

the 3 seconds is that being calculated by running the query in a SQL tool? A better way to benchmark is to run Connect and thread logs and isolate the transaction through CS. Then reach out to OT with that metric that may be better.You can also use Developer tools to see how long the network indicates the load is being painted on the browser

Luis Reis

Hi,
Yes, directly in the database the response is fast, but the content server's smart view is taking a lot of time. We test with different users in different situations such as in the office or at home

Greg Griffiths

What does the Developer Tools show here, is there a delay on getting the values back ? or is it in the Render part ?

Luis Reis

Hi,
The delay is in opening the field, and even after loading, this window crashes until it stabilizes and the client is able to search through the filter results. It takes about a few minutes in smart view e a minute in classic view

Screenshot 2024-03-21 161030.png

Greg Griffiths

does the same thing happen with other fields e.g. Text Popup / standard TKL or is it just the ADN TKL ?

Luis Reis

only in the field ADN TKL, in classic view it performs better but is still slow. In the database the query is very fast, on the server too, but not in the user view

Greg Griffiths

in that case its likely to be in the SmartUI JavaScript code, you can check with OT Support to see if they have any patches / known issues etc with this case, if not then it will need to be investigated.