"ADN Table Key Lookup" field takes too long
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
Comments
-
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
1 -
What does the Developer Tools show here, is there a delay on getting the values back ? or is it in the Render part ?
1 -
does the same thing happen with other fields e.g. Text Popup / standard TKL or is it just the ADN TKL ?
0 -
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.
0
Categories
- All Categories
- 117 Developer Announcements
- 52 Articles
- 146 General Questions
- 136 Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 912 Cloud Fax and Notifications
- 82 Digital Asset Management
- 9.3K Documentum
- 30 eDOCS
- 173 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 6 XM Fax