Large Record Sets and Flash

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

turbidity - 04 Dec 2006 02:25 GMT

I was wondering if anyone has suggestions for how to handle big recordsets with
flash remoting. First, would you suggest handling things client side or server
side? I'm looking at doing recordset paging for a gallery, that I'd like to be
scalable I guess the question is whether it is better to make one call and
then parse it locally, or make a call to the server every time someone goes to
a different page of the recordset. I'm looking to display 50 at a go.

And beyond that would anyone have a suggestion for handling the recordset
extraction server side? I'm using ColdFusion, but I can't use the startrow
attribute in the cfoutput element because the records are going to Flash. I can
think of a way doing queries of queries, but it seems like that could get into
even more calls to the database. My primary keys have gaps in their sequence so
I can't just say get records with keys between 50-100 because that may not be
59 records.

Any thoughts?

Reply to this Message

Tekkaman Cypher - 12 Dec 2006 23:52 GMT

Hi TURBIDTY, my recommendation because I'm currently working on a project that
deals with what your talking about is to make an XML call to CF and then have
it send back the information. If you're pulling multiple row instance within
your tree, some nice toys to look at within Flash are the DataSet component to
which you can bind the DataGrid component to.

There's tons of ways you can skin this kind of cat, but, the easiest method I
can say without getting too detailed is doing it that way. Adobe in the
developer section has tons of tutorials and examples on this can be achieved.
I think there are several that use CF as a backend.:grin;

Reply to this Message

Webmaster Forum / Flash / Flash Remoting / December 2006

Large Record Sets and Flash