Save the query result to a session var or to a file as part of the page processing. Then have an ajax call to a secondary page that will do the insert or bulkinsert. Once the page has loaded (onLoad) have an ajax call to the secondary page.
That's one way. I'm quite sure there's many others. 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:335467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
