reducing the loading time at the time of filter conditions apply on Table level

[Manohararuna]

Hello Everyone,

       O have one approval Table having the 20 lakhs records. But it takes long time to load the atble at the time oe opening

2.if i applied filter condition like assignment  group, approver , approval for , approving it takes almost 5 minutes.

I want to reduce the time at normally table opening time and filter condition applying time.

Please provide the solution this proble.

[Ankur Bawiskar]

@Manohararuna 

it all depends on where are you applying this filter?

where do you wish to use that?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Manohararuna]

Thanks for you solution Ankur, but i am trying to applying the all filter condition on Table level only. If you have any short cut or solution please let me know

[Robert H]

Hello @Manohararuna ,

Which table is this about? Approvals [sysapproval_approver]?

How many records are in that table?

How long does it take if you go to the list view of this table, without any filters applied?

After you try the above, please go to System Log > Transactions. Filter the list as follows:

Created on today AND

Created by {your user ID} AND

Type = List AND

URL | starts with | /sysapproval_approver_list.do

Then open the most recent Transaction and post a screen shot of its details, which should look like this:

Regards,

Robert