django-infinite-pagination icon indicating copy to clipboard operation
django-infinite-pagination copied to clipboard

efficiency conceirn

Open tbarbugli opened this issue 12 years ago • 1 comments
trafficstars

Hi, If concerned about performances, you should consider some better way to get items than using offsets, your implementation is going to get slower and slower and prone to show duplicated items (unless you "freeze" by filtering the queryset results)

tbarbugli avatar Nov 01 '13 11:11 tbarbugli

+1 This may be the way to go: http://www.reddit.com/r/programming/comments/p7lgl/sql_pagination_in_constant_time_using_the_seek/

Edit: Nevermind, that method has several issues. Works fine for infinite scrolling, though.

nitely avatar Apr 09 '14 17:04 nitely