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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
