[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Data streams

• To: "Stephen E. Beller" <sbeller@n...>
• Subject: Re: Data streams
• From: Peter Hunsberger <peter.hunsberger@g...>
• Date: Mon, 6 Dec 2004 16:23:30 -0600
• Cc: xml-dev@l...
• Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=iETkFwbvcu6h7bBcPYwkqARuld/ZbPLKCNgx0iZ+OT4seZVSXfVAbULs4qqIXN57QSUX5axWizVE5POg60CM/0tPmHmNibPm3YYu7Vc63FFF2uiXmivySDauyahdg3yakXDSw94YKHlNHy4U2vl0/kET2BTQKN1HSOHuP/oV9cI=
• In-reply-to: <001301c4dbdb$8d721040$6501a8c0@dell8100>
• References: <41B4B62D.5060008@m...> <001301c4dbdb$8d721040$6501a8c0@dell8100>
• Reply-to: Peter Hunsberger <peter.hunsberger@g...>

On Mon, 06 Dec 2004 16:35:48 -0500, Stephen E. Beller <sbeller@n...> wrote:
> In consideration of Elliotte's reply, I went back and looked at the XML file
> Excel generated. Here's what I found ...
> 
> Every one of the XML data elements had this tagging structure:
> <Row>
>    <Cell><Data ss:Type="Number">1</Data></Cell>
> </Row>
> 
> In contrast, the CSV had this structure: 1,
> 
> That's a 50 characters to 1 difference for each data element.
> 
> I doubt that all those XML tags are necessary if you're rendering the data
> in something other than a spreadsheet. But if you are planning to use a
> spreadsheet, then the 50 to 1 ratio is valid, it seems to me.

Use the number 10, now the difference is 51 to 2 or a ratio of ~26 to
1.  Use the number 100 and the ratio is 52 to 3 or ~17 to 1.  Six
digits? 56 to 6 or ~10 to 1. Now add multiple columns of data (as any
realistic example would do) and the ratio falls even farther.

<snip/>
> 
> So, this benchmark test still points to a huge difference in file size and
> in unzipping and parsing time when you compare a large data array in CSV
> compared to XML.

Maybe, maybe not, the bench mark needs to be more realistic before you
draw any conclusions about "huge".

-- 
Peter Hunsberger

• Follow-Ups:
  • RE: Data streams
    • From: "Michael Kay" <mike@s...>
  • RE: Data streams
    • From: "Stephen E. Beller" <sbeller@n...>

• References:
  • Re: Data streams
    • From: Elliotte Harold <elharo@m...>
  • RE: Data streams
    • From: "Stephen E. Beller" <sbeller@n...>

• Prev by Date: RE: Data streams
• Next by Date: Re: Data streams
• Previous by thread: RE: Data streams
• Next by thread: RE: Data streams
• Index(es):
  • Date
  • Thread