Or cfqueryparam if you're not already using it... Although if you're selecting a single query and using that to drive hundreds or thousands of email, the database may not have anything to do with the bottleneck. But he's right, you ought to try and isolate it to make sure it's CF and not some other bottleneck before you spend a lot of time working on a solution that may not work.
> Interesting. Do you think that the stored producedures > would provide a greater performance boost than a > conversion to Java ? Is that what you are saying? > What about a combination of C++ & stored procedures? >>Are you sure that it's ColdFusion that it slowing the task >>down? I'm not >>sure if moving it to Java would provide a noticeable >>increase in performance >>considering that the server already converts your CF code >>to Java bytecode >>before it's executed. Perhaps you could also look at >>moving your data >>transactional code to stored procedures (if applicable). >>What do your logs >>say? Are the pages doing the processing taking large >>amounts of time? s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201891 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
