It takes to much time to load records

[ADIL9]

Hello,

I have an issue when trying to load records from change_request table based on filters that we fill using some fields.

the problem is when we click on submit, it takes a lot of time and apparently it scans the whole table instead of going direct to the specified filter.

is there a function or a way to minimize loading time?

Thanks,

[Kieran Anson]

Hi Adil,

"it takes a lot of time and apparently it scans the whole table instead of going direct to the specified filter." - What do you mean by this, is this just an observation or a statement of what you're seeing.

Slowness can be attributed to a number of areas. In your case, there is potentially a long running transaction because of a business rule. If you update the record but right click and use the save action, does it still take a long time?

How complex is your filter on the change_request table, more complex filters will take longer to complete.

[ADIL9]

Hello Kieran thanks for your reply,
what I mean't by "it takes a lot of time and apparently it scans the whole table instead of going direct to the specified filter" is what the client created a ticket for.

the filter used is based on some fields on the customized widget, however when selecting a specific date it loads faster but when filling those fields it takes time for examle 10000ms or more to complete the transaction.

[Bhavana20 · Accepted solution]

Hello,

1)We also faced similar issue earlier, that was because we work in the domain seperated environment and in the backend there are too many records and hence we added the filter Domain is "Mycompany name" and the performance was improved, I am not sure whether this going to help but alternatively 

2)under system definition ->Transaction quota rules , you can set the maximum duration time according to your requirement.

I am not sure if it helps you but post the right answer in the community if you found the solution.

Thanks,

Bhavna

[ADIL9]

Hi Bhavna,
I'm going to try it thank you !