On Wed, Dec 12, 2012 at 11:16 AM, Edward Chanter <[email protected]> wrote:
> my first question is whether CF is best for > this or if I should try to do this with SQL queries. If the answer is 2 can > anyone point me in the right direction as to how I would go about doing > this in native SQL? Or is there a more efficient way to do this in CF? > Making all the data do a round trip to CF and then back to the Database is always going to be slightly slower. Doing this 90K times in a row may magnify this effect. If it's slow in CF, then yes, write it in SQL. Only you can answer this question. If it's a one time migration though, who cares if it's slow as long as it happens. Explaining how to write the SQL to do this is beyond the scope of a simple email, but I would start by taking a look into the syntax for "SELECT INTO", which will allow you to select data from one table directly into another. If you need to massage the data first, then it will get more complicated. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook <http://www.facebook.com/cameroncf> | twitter<http://twitter.com/cameronc> | google+ <https://profiles.google.com/u/0/117829379451708140985> .... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
