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
Ajax?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
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
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
I've dealt with this issue time and time again. For instance, you want the
results to be downloaded in an excel document but you don't want to
compromise the time it takes to render just the HTML.
I have an image that is hidden and a spinner saying 'loading excel results'.
Then at page load an
5 matches
Mail list logo