Advice on large sets of data

[Tim Vanderlois]

For normal data display to a user I'm paginating data result sets which has a great response time. I'm now however; challenged to export a large set of data to excel (about 80,000 rows). My taffy api get query isn't overly complex and runs for about 10 seconds; however the data result must be timing out while getting jsoned. 

I do have the luxury of CF for the API application (obviously) and CF for my consumer application. Although these are separate cf applications, I'd prefer not to duplicate the query but running out of options. I cannot cfinclude within a taffy recources cfc (tracked issue)  and also cannot invoke the get method from the consumer application as the resource cfc extends taffy.

For a quicker response time - I'd probably prefer the ability to invoke the resource directly just to get a query object rather than serializing and deserializing that amount of data then build the excel output.

Any thoughts?

[Adam Tuttle]

Sounds like you need a service class that both applications can share to get the data -- your API would paginate and return as json, your consumer application could alternately package up as excel.

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.