Which database? Do you have bulk insert capabilities? On Sat, Feb 14, 2009 at 5:28 PM, Mike Soultanian <msoul...@csulb.edu> wrote: > > Hey everyone, > I am pulling a song listing from another website that's in JSON format. > I already figured out how to bring it into CF with deserializeJSON(), > but now I need to put all that data into my database. There are over > 60,000 songs in their database so that means I have to insert over > 60,000 structs (song title, artist, id, etc) into my database. What is > the most efficient way to do this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4