1 Reply Latest reply: Dec 12, 2006 3:52 PM by Tekkaman_Cypher RSS

    Large Record Sets and Flash

    turbidity Community Member
      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?
        • 1. Re: Large Record Sets and Flash
          Tekkaman_Cypher
          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.