Paging best practices

[Jose Gosende]

Hi,

I'm dealing with large data sets (> 50k rows) and was wandering if anyone had implemented a pagination system with Taffy? Using ACF 10 and MS SQL 2008, in case that helps.

Thanks,

Jose

[Adam Tuttle]

It's tricky. You definitely don't want to select all of the rows and then loop over just the desired set (e.g. cfoutput with startrow and maxrows attributes)

You really want to do pagination within your SQL. Different databases support different syntaxes. I like MySQL's the most:

select ...

from ...

limit {offset}, {rowcount}

So if you did "limit 100, 50" you'd get 50 rows starting at 101. Or is it 100? I can never remember. :)

Adam

--
You received this message because you are subscribed to the Google Groups "Taffy Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to taffy-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Cory Silva]

Were are using the Odata v2 spec with Taffy.  But you could also use jQuery.param() to pass some parameters over the URL.

http://api.jquery.com/jQuery.param/