RE: XML Vs. CSV/Text
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
XML Vs. CSV/Text
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:275150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML Vs. CSV/Text
Well, if you go the CSV route, you may encounter a problem with ommitted elements if you're using the CF list functions. ie. listLen (a,b,c,d) = 4, listLen(a,b,,d) = 3 -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 10:06 AM To: CF-Talk Subject: XML Vs. CSV/Text 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:275162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 ~| 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
