Improve performance: to many operations reading same view files in retrieve/list tables

[acacha]

For example using Sleeping owl datatables display with a table of 100 rows an 10 columns Sleeping Owl do at least 1000 read file operations with a great impact in performance.

A lot of views are readed many times with the same content (my table have 5 sting columns so this views is called 500 times) I suggest to implement some way to avoid rereading same file again and again

See:

https://laracasts.com/discuss/channels/laravel/how-to-improve-performance-when-calling-same-view-multiple-times?page=1

for more info

[s6carlo]

I think the solution is not caching, but building the query in a different way. Now the relationship are not built using a join but a query for each row, while a single query with a join should give the same result.

I don't understand the "Eager Loading" display option, can be used also for datatablesAsync display? How does it work?

A different approach to query building will dive also these feature :

• search in column from joined tables #112
• sort by column from other table
• Column Filters in all columns