Wow that is cool.  For everybody’s benefit, here is the documentation:


http://wiki.openbluedragon.org/wiki/index.php/CFQUERY

*BACKGROUND Attribute*

Open BlueDragon allows use of a BACKGROUND attribute with CFQUERY. When
BACKGROUND is set to TRUE, the query is run in a background thread and
processing does not wait for the query to complete before continuing.

This differs slightly than using
CFTHREAD<http://wiki.openbluedragon.org/wiki/index.php/CFTHREAD> to
run a query. When the BACKGROUND attribute is used, a single background
thread is used for all background operations, and the background operations
are queued. When CFTHREAD is used a new thread is spawned.

Two log files are kept to track the progress of these queries.

§  querybatch.log - for successful executions

§  querybatch-errory.log - for exceptions and errors, printing out the SQL
statement of the problem



Thank you,



Randy





*From:* [email protected] [mailto:[email protected]] *On Behalf
Of *Matthew Woodward
*Sent:* Monday, July 30, 2012 9:56 PM
*To:* [email protected]
*Subject:* Re: [OpenBD] Re: Valid Use Case for CFTHREAD



On Mon, Jul 30, 2012 at 1:20 PM, Aaron J. White <[email protected]> wrote:

For what you're trying to do you probably want to use the background
attribute of cfquery instead though. That will make openbd add your query
to a queue and run it in the background when resources are free.



Right, if that's all you want to do I'd go that route. Simpler and makes
the code clearer to boot.



-- 
Matthew Woodward
[email protected]
http://blog.mattwoodward.com
identi.ca / Twitter: @mpwoodward

Please do not send me proprietary file formats such as Word, PowerPoint,
etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html

-- 
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en

-- 
online documentation: http://openbd.org/manual/
 http://groups.google.com/group/openbd?hl=en

Reply via email to