mysql.. I have admin access to my instance... Maureen wrote: > 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:319331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4