Processing the XML with Java rather than CFML will speed things up. check riaforge.org or cflib.org and the adobe exchange, somewhere there is a XML parser that does just this and may give you the boost you want.
Russ On Tue, Feb 15, 2011 at 12:15 AM, Casey Dougall < ca...@uberwebsitesolutions.com> wrote: > > On Mon, Feb 14, 2011 at 7:07 PM, Matt Robertson <websitema...@gmail.com > >wrote: > > > > > Client is running mySQL, But a SQL Server could probably be arranged > > if we have to. Kind of a painful investment for them, though. > > > > > > Well seems there is support for this in mysql as well but examples use > something simular to BulkInsert where the xml file is on the MySql Server. > > http://dev.mysql.com/tech-resources/articles/xml-in-mysql5.1-6.0.html > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
