If you're talking about 200 copies, each of 150,000 records, then Session and Application storage are going to be feasible only if you have sufficient physical memory on the ColdFusion server.
200 x 150000 x ?? = 30,000,000 x ?? bytes average record size So, if an average record in the report set is very limited, simple data, say 20 columns each at 20 bytes (say small varchars or numbers), then you're still looking at caching in memory something like 30,000,000 x 400 bytes = 12,000,000,000 bytes = 11.2 GB Better have a $*!tton of memory on that box ... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331364 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
