I'm not too sure of the effectiveness of Parallel Execution on db side by different DBMS vendors, have not read any substantive metrics to support that, hence, I would hesitate to explore, and the other reason is logistics. I've exloited substantially on database side for my applications and experimentations. I know all what you described, probably I know a bit more about database technology than most developers here, however, no need to get into that. For the particular experimental app, data integrity is a non issue from my app perspective since limited function of DML would be used, that is, no data updates (insert, update and delete) would be involved. However, if the source database has data integrity problem, then, my app or any else's app for that matter may be put in a aweful spot.
Well, my posting was not exactly that clear about the goal other than direction, and it was intended this way. However, it may have negative impact on understanding. >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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
