Skip to main content
Participant
December 4, 2007
質問

Update Database with XML

  • December 4, 2007
  • 返信数 1.
  • 321 ビュー
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.
    このトピックへの返信は締め切られました。

    返信数 1

    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.