Incubator » CB Activity

Consider reviewing new pagination options as we don't need to know the total for anything other than Like, Comment, and Tags which is handled by prefetch.

This is the only thing holding back remaining performance improvements. Currently the following test environment is giving the below results.

Rows: 1 million
Count: 20ms
Result: 1ms

In short the count query, just to see if there's another page not to actually display count, is 20 TIMES SLOWER. There's just no need for this. In the SELECT just grab more than 1 row than what we need and set in the stream that there's another page.

Note second query is 1ms because it's acting off SQL memory. The overall performance gain will likely be around 2-5ms and save a little memory.