Is there anyway to force a query to finish processing even if the user
leaves the page before it is finished? We have an application that lets
our users run a report and it generates a delimited file based on the
query. We would like it so that the file will be generated and stored
in a
Invoking it with CFSchedule will execute a .cfm separately from the page
being viewed (so it's not dependent on http keep alive)
--
Billy Cravens
[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Is there anyway to force a query to finish processing even if the user
leaves the page before it is
If I am correct, I believe that this already does happen.
- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, December 11, 2000 11:40 AM
Subject: Any good ideas?
Is there anyway to force a query to finish processing even if the us
.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 8:40 AM
To: CF-Talk
Subject: Any good ideas?
Is there anyway to force a query to finish processing even if the user
leaves the page before it is finished? We have an application that lets
Have a script that will schedule that as a one time task.
Then if they leave...the cf scheduler will run it for them.
???
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 11:40 AM
To: CF-Talk
Subject: Any good ideas
At 10:40 12/11/00 -0600, you wrote:
Is there anyway to force a query to finish processing even if the user
leaves the page before it is finished? We have an application that lets
our users run a report and it generates a delimited file based on the
query. We would like it so that the file will
to bring down our CF server though. Does anyone
know if CF has a limitation on the size of record sets it will return
back?
Thanks
Misty
-Original Message-
From: dylan [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 10:48 AM
To: cf-talk
Cc: dylan
Subject: RE: Any good ideas
From: [EMAIL PROTECTED]
[best practice in re initiating and completing time intensive queries]
Based on what has been written in this thread so far it looks as
though CFAS should have no role other than serving as a
front end acceptor of query tasks. The data and processing load
would seem to
IL PROTECTED]]
Sent: Monday, December 11, 2000 9:45 AM
To: CF-Talk
Subject: RE: Any good ideas?
dunno - had you thought about doing your processing entirely SQL server side
- using stored procedures and DTS?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 11
This is not a task for a web request, you should really fire an another
process to do reporting. Use cfexecute and what ever they are currently
using, if it ain't broke...
Justin
Nope not these queries. This database is huge, I am talking hundreds of
GIGs to terabytes. Average queries on this
Alright thats it! No one is allowed to make any more phone calls, you
all are making my database entirely to big. :)
Misty
-Original Message-
From: daniel [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 11:45 AM
To: cf-talk
Cc: daniel
Subject: RE: Any good ideas?
dunno
]]
Sent: Monday, December 11, 2000 12:34 PM
To: cf-talk
Cc: macarthy
Subject: RE: Any good ideas?
This is not a task for a web request, you should really fire an another
process to do reporting. Use cfexecute and what ever they are currently
using, if it ain't broke...
Justin
Nope not these queries
12 matches
Mail list logo