I am adding lazy loading so all data should not come up at once to pivot. say 1000 records and when user starts scrolling and had scrolled 500 records, backnd api call will be made to get next 1000 records and so on. So do we have any scroll event so i can make backend call?
in order to do that (as i have million for records in pivot) i need some client side changes too.
like for filter ,since i will have only 1000 records i have to customize filter option so type ahead in search box should search in bigger set of data not whats present in pivot at that moment of time.
something like :
document.body.addEventListener(‘contextmenu’, onRightClick); something like this but ON flexmonster table (whole table scroll)
and eevent as onscroll down.
can you assist?
Thank you for the detailed explanation. For now, we do not have such sort of events available. If you need to rich a better performance please consider using the following approach – http://www.flexmonster.com/blog/sql-pivot-table-best-performance/.
i have already optimzed query and used compression.
we need something on client side and onScroll event we need to populate more data in pivot rather then loading all.
specially in flat view. Any suggestion? would you be able to add ONscroll of data in table event in next couple of months by any chance?
Currently, we are not able to come up with any other suggestions. Please find the answer about
onscroll in another thread.