On Sat, Feb 14, 2009 at 8: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? > > 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:319327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4