CLE table is not opening due to increased size

gopalach77

While running capacity ledger entry it is not opening due to increased size. Fields 71, 72 , 76 and 77 are flowfields to value entry table. I suspect due to this it is not opening quickly. can anyone advise me what to do to open the table quickly irrespective of its size.

Thanks in advance for your reply!

Regards,
GK

kriki

First try to open the table in a form/page without the flowfields to see if it is faster.
Then add the flowfields 1 by 1 to see which flowfields is slow.
Probably you will need a good index for that flowfield. If there is, you probably need to do regular indexrebuilds.

gopalach77

While running the Capacity Ledger entries form it is opening quickly, but when i am opening the table i am not able to.
for your information, I have 4.5 crore value entries, 35lakh CLE, 3.6 crore ILE. I am running on 32GB ram system. what best can i do to open the CLE table?