C
carl.williams
Guest
Thanks for the reply, thanks for the example code and for the workshops at the EMEA PUG last year. It is the count function taking the time, a simple for each product with 30k products and no filtering that takes 0.5 seconds. I was thinking of the JSDO keeping track of the last filter used (where clause) and only calling count if the filter changes. If we are on the last page and peeking ahead we see there more records (products added) yet to come then add an entire page worth of records to the count, eg. 3000 becomes 3020 with a page-size of 20. Thus adding another page to the grid. If during paging we reach a page where it is evidently the last page (less than a page of products returned as products deleted) then we set the count to be number of whole pages + records on this last page. What do you think?
Continue reading...
Continue reading...