Thanks guys for your suggestion. I'm using SQL Server 2k5 and the likelihood is that this file will only ever be parsed by my application, So I think I may take your advice and opt for the CSV, at the end of the day its only a log file, nothing very complex and is basically a flat version of the database table.
Thanks again, Rob -----Original Message----- From: Judah McAuley [mailto:[EMAIL PROTECTED] Sent: 13 April 2007 18:08 To: CF-Talk Subject: Re: XML Vs. CSV/Text You don't mention what db you are using but I've had good success on MS SqlServer writing to a csv file and then doing all the processing to the database entirely in SQL using the BULK INSERT INTO command. If you're able to go that route with whatever db you are using, I'd opt for csv (or tab delimited if you might encounter commas). More compact than XML and no application server processing required. If your data needs to be more heavily processed (like lookups on ids to match something else, date parsing, etc) or it may end up being used by other applications in the future, then I'd go the XML route because its more verbose and self-descriptive. Judah Robert Rawlins - Think Blue wrote: > Hello Guys, > > I'm building a non-cf application at the moment, who's logs will be parsed > by a ColdFusion application after having them passed to it via a web > service. I'm now making the choice of log format for my other application, > what are the benefits of using XML over CSV or other delimited files? > obviously the XML has more of a structure, but what about parsing speeds? Am > I likely to see any benefits there of using XML? > > > > I'd be interested to hear your thoughts, I'm not planning to do anything > particularly interesting with the XML, simply parse through the records and > insert them into a database table. > > > > Thanks, > > > > Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
