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?
I am able to pull down chunks of song data (i.e. pull first 1000 songs, then pull then next 1000, etc), and then would I loop through the array and individually insert each struct into the database? It seems like that would be like a slow process but I don't know how else I'd do it. Any suggestions would be much appreciated! thanks! Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:319326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
