search

hjalmers / angular-generic-table

A generic table for Angular 2+. Generic table uses standard markup for tables ie. table, tr and td elements etc. and has support for expanding rows, global search, filters, sorting, pagination, export to CSV, column clicks, custom column rendering, custom export values.
https://hjalmers.github.io/angular-generic-table/
MIT License
104 stars 55 forks source link

Pagination, Sorting with Lazyload:false #198

Open Liahus1996 opened 6 years ago

Liahus1996 commented 6 years ago

Hi Mate ,

I have a scenario where i load the data from a recursive query in database which takes around 1 minute to complete , in this case i will get around 20K - 100K+ records.

Do you recommend me to still go with Lazyload:true ? or is Lazyload:false is better in this case ? since for each sort/pagination i cant wait for 1 min to execute.

hjalmers commented 6 years ago

Hi @Liahus1996, if your able to cut down the server load time by getting a smaller subset I would definitely go for lazy loading and if you optimise your query it shouldn't have to take a minute to return say a 100 records. If you for some reason can't cut down on the load time I guess it's better to have one long loading but it also comes down to the type of data you have and how often it's updated/changed. If the data is pretty static, fetching it once and going through pages and applying filters etc. client side might work but if the data changes often you still might want to go back to the server and get the latest data.

I general I'd say put as much logic as possible on the server and make the client dumb.