daveVk - 5:09 am on Jul 12, 2013 (gmt 0)
I take it the slow process it selecting the subset of the 120 million to go into each page ?
Wondering if there is scope to change table indexing to make selection faster. Is maintaining direct index between page(userId) and page records possible ?
Have you some profile tool to find bottleneck ?