Limit and Columns with huge tables

[portapipe]

Hi, it's me again 😄 I have a customer with a very old and untouchable website. One of his db table has over 16k heavy rows that I can't limit with GC (the limit seems to not work and not limit at all) plus the columns property doesn't filter the data but just show that column and that is quite heavy for the page.

I should divide that rows every 5k rows but the limit ignore his job.

Maybe I use something wrong? Thanks :)

[adrianogoncalves]

Try to change the theme to datatables.

[portapipe]

Hi. I have the premium bootstrap theme installed. Tested with other theme, same problem. And I think $select = "{$this->table_name}.*"; is not so good for performance

[mckaygerhard]

is 2021 and this problem still happened..

[scoumbourdis]

Hello @mckaygerhard, I agree with you but please keep in mind that this has been resolved on Grocery CRUD Enterprise. This change that was needed unfortunately required a complete refactoring of the code in order to have better performance and this was literally impossible at the old code base.

[mckaygerhard]

It is understandable that the old code is not possible, but I see that so little in the "new code" since when you say "enterprice" you make it seem like what better to buy than to solve ..

I have a partial solution to the problem in the old code modifying the model, thus giving a real support to the "where" since the boostrap is not really taking into account @scoumbourdis

in fact the problem is pretty simple.. the "where" is not honour, by example i made a form that forces the where dinamically, that is not take if i refresh the page.. so a ajax resend of that solved the problem!