Thu, 24 Sep 2026
Login

Datalist load time

Confluence User - 31 Jan, 2023

Hii there,

I have a  datalist with around 2 lakh record . and another table of user i joined the table and applied the filter to show records based on login user company and some other filter . its taking around 15 to 20 seconds to load the datalist. however if i dont join the table and does not apply any filter its loading within 3 to 4 seconds. Similary if i increase the filter condition its load time is increasing. Please find below screenshot for my filters and query and advice how can i reduce the load time. Also i tried the same with jdbc datalist binder but thats taking more time... 


Thanks in advance.

datalists

2

Confluence User •
01 Feb, 2023 •
confluenceUser •
•
confluenceUser •

Hi, if you are dealing with large amounts of data, you should perform optimizations on your database tables and columns as per Performance Optimization and Scalability Tips#OptimizeyourAppandDatabaseQueries. The actual steps would depend on the type of database server you are using. For example in MySQL, you can make use of Slow Query logs and the EXPLAIN keyword to identify the bottlenecks so that you can add appropriate database indexes to speed up the slow queries.

Confluence User •
01 Feb, 2023 •
confluenceUser •
1 •
confluenceUser •

Login as admin, go to Monitor > Performance. Find the app and the menu, you will be able to locate the slow queries.

From the screenshot, you will need to add indexes for columns:- 

usernames, requestStatus, status

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
How to customize datalist process formatter
Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.
Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.
I want to have a visibility control for hyperlink based on the date in a list builder, what type of operator I should use and how?
I Want to Add , Add to Cart functionality like Swiggy or Zomato This is possible in joget?
List Question
Create Folder on the Home Page
Async search list with ajax
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print