Update Database with XML

[BrooklynDumbo]

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.

[Newsgroup_User]

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.