Skip to main content
Participant
December 4, 2007
Question

Update Database with XML

  • December 4, 2007
  • 1 reply
  • 321 views
We update several thousand product prices in our MYSQL database daily using an XML feed.

We can update the database using by looping over the XML and updating the database on an item by item basis but that seems awfully inefficient.

Is there a better way?

Thanks.
    This topic has been closed for replies.

    1 reply

    Inspiring
    December 4, 2007
    Probably.

    But a more detailed answer is going to depend on what database
    management system you are using and what its specific bulk
    loading/updating capabilities are. This may or, most likely, may not
    involve ColdFusion at all.