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 December 2000 17:37
To: CF-Talk
Subject: RE: Any good ideas?
Nope not these queries. This database is huge, I am talking hundreds of
GIGs to terabytes. Average queries on this site do not get returned any
where near as fast as the template could process. I thought about using
the scheduler. Maybe instead of runing a query immediately just have it
insert the filter criteria into a database and have a scheduled page go
out every 10 or 15 minutes and see if any new queries need to be run. I
am actually running to go talk to our DBA guys to get the average
processing time for the queries. I am beginning to wonder though if
these queries are going 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?
In a lot of situation, CF finishes processing before all the
data/results/etc. are returned to the client's browser. You could use
CFSCHEDULE to process the query 15 or 20 minutes (the scheduler looks
for
new tasks every 15 min so cover the window) after the request was
generated
by the user.
-----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
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 directory for them to come back at any time to download. It is not
feasible for the user to sit there and wait for it since these are some
big queries. If this is not possible to do, does anyone have any ideas
on how we can get these generated.
Oh, it is currently working like this but on a different platform,
different software and doing some weird things to accomplish this. I
need a CF solution to this.
Thanks,
Misty
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
