Infinite scroll with server-side processing and the processing indicator, and pipeline question

Infinite scroll with server-side processing and the processing indicator, and pipeline question

oswikioswiki Posts: 9Questions: 0Answers: 0
edited March 2011 in General
Hi! I love the new "infinite scroll" feature. I am noticing one oddity, though.

I'm using infinite scroll in conjunction with server-side processing. When scrolling down, I see the "processing" indicator appear, and then the next set of results appears (which is awesome!). When I reach the very end of the list, though, the "processing" indicator appears, and never disappears. It looks like it's processing more results, but there are no more results. Is there any way to prevent this from happening?

Also, I am wondering if pipelining works with server-side processing and infinite scroll, to make it run a little faster?

Thanks!

Replies

  • oswikioswiki Posts: 9Questions: 0Answers: 0
    Nevermind! This wasn't a DataTables problem, it was a MySQL problem.

    Apparently, when using three ORDER BY sorts, and then using a LIMIT clause, things hang on the last page of results. Say there are 82 results, and I'm at LIMIT 80,10 -- this just hangs. (LIMIT 80,2 works, but for some reason, over-reaching with that offset just doesn't work.) But, when I use just two ORDER BY sorts, it all works like a charm. Weird, maybe a bug. Anyway, long story short, it works fine!

    Both the "processing" indicator and pipelining work like a charm with server-side processing, using infinite scroll. This is awesome!
This discussion has been closed.