I think that this sort of work should really be done outside cf. Java, as matt suggested, is more suited, but additionally, this work may be done in the database. Most databases are multithreaded by nature anyway. The key is ensure that you minimise your locks , where you can, you may need to use temp tables too. Look at DTS and Parallel Execution in Books OnLine if you are using SQL Server, other dbs have different methods to do the same thing.
One issue that no-one mentioned is the data integrity in clustered app. If you have a multi-threaded process you have to ensure that the data remains correct. If thread A changes Data that thread B needs etc.. you will end up with issues. One method to over come this to take a snapshot of the data before doing your work, but that may not always be possible. WG ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
