When a list come close to about 400 records, it stops displaying in front end and page after loading for about 30sec finally throws 500 Internal Server Error. If I reduce number of records to about 300 it works (although is still slow). It doesn't matter how many rows I set to display at once. And I have about 30 elements in that table, displaying in the list view only 10 of them.
Is there a limit on amount of rows per table? I did some research and users only complained when they had more than 50 elements per table, it is said that number of records doesn't matter, however it does in my case. Is there anything I can improve to fix those issues? I do not want to split that table into smaller tables.
Is there a limit on amount of rows per table? I did some research and users only complained when they had more than 50 elements per table, it is said that number of records doesn't matter, however it does in my case. Is there anything I can improve to fix those issues? I do not want to split that table into smaller tables.