Some ideas to explore: cfhttp with an immediate timeout cfthread CF Event Gateways
Writing 500 rows to a database table should only take a few milliseconds, which would be unnoticeable relative to the amount of time you say the page takes to load. If the database is slow for some reason, perhaps create a light-weight database table optimized for fast inserts. Trying to spawn another thread for database inserts might not be worth it unless the database inserts are noticeably slow. To optimize calls to external systems, explore the cfthread tag, assuming you are using the Enterprise edition of CF. -Mike Chabot On Mon, Jul 19, 2010 at 11:18 AM, Che Vilnonis <ch...@asitv.com> wrote: > > I have a script that pulls data from several external sources and returns > the top 500 results and takes about 3-5 seconds to render. To speed things > up, I want to database the results for later use. How can I database the > results while the user is viewing the page without the increasing the pages > render time? In other words, how can I write the data to a database... but > only after the page has been completely rendered? What would be the best way > to do this? I'm currently using CF8. > > Thanks Che > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm