Hi Charles,thanks a lot for your efforts. I'm replying this way because your mail was included in a digest of the Sedna discussion list, but it does not appear in the on-line discussion forum, nor did I get a copy. It seems you replied to the wrong thread ("Bad performance under Linux" instead of "Performance using XML:DB 1.0 API").
I've repeated our test under various conditions and although the absolute values were somewhat better this time, the relative speed difference remained more or less the same. I understand that it's the parsing of the XML document that makes the difference while the actual upload speed doesn't differ significantly, and that the XML:DB spec leaves no room for improvement here.
Although one must allow for some variation due to different test enviroments and set-ups, some questions remain to me.
- Why is inserting an image of 28 KB equally slow? - Our XML doc (see attachment) is only 2 KBs big, so upload time should be a small fraction of the one you measured for a 17 MB doc. However, in both cases we see millis in a 3-digit range (around 400 millis on my 1.6 GHz XP Laptop, content is inserted into XMLResource as a Java String). I have no explanation for this. Do you re-use the parser?I don't know if streaming from another location may be helpful. The XML docs are delivered via a web service and are already in memory.
Thanks again, Michael -- *----------------------------------------------------------- * Michael Schäfer Statistisches Bundesamt * Software-Entwicklung II C * XML, Werkzeuge, Standards Gustav-Stresemann-Ring 11 * D-65189 Wiesbaden * Telefon +49 (0)611 75 36 52 Germany * Fax +49 (0)611 75 39 51 * * E-Mail: Internet: * [EMAIL PROTECTED] http://www.destatis.de * http://www.statspez.de *-----------------------------------------------------------
<?xml version="1.0" standalone="yes"?><observationContext xmlns="http://www.destatis.de/schema/idb/1.0" id="0" version="0"> <observationContextKey> <observationAreaID>08</observationAreaID> <statisticsID>0001</statisticsID> <referencePeriod>620070000</referencePeriod> <observationUnitID>000000079645</observationUnitID> </observationContextKey> <observationContextStatus>USABLE</observationContextStatus> <resourceEntry version="0" id="0"> <resourceContentType>UNSPECIFIED</resourceContentType> <status>REGISTERED</status> <internalID>08000120080922115319000000000020</internalID> <externalID>7965_6</externalID> <channel>PAPER</channel> <function>UNSPECIFIED</function> <pageInfo>6/0</pageInfo> <documentTypeID>DATML_RAW_2</documentTypeID> <documentTypeVersion>2.0</documentTypeVersion> <mimeType>text/xml</mimeType> <bytes>0</bytes> <resourceLog> <created id="0" version="0"> <timeStamp>2008-09-22T11:54:46</timeStamp> </created> <registered id="0" version="0"> <timeStamp>2008-09-22T11:54:46</timeStamp> </registered> <collected id="0" version="0"> <timeStamp>2008-05-15T03:07:49</timeStamp> </collected> </resourceLog> </resourceEntry> <resourceEntry version="0" id="0"> <resourceContentType>IMAGE</resourceContentType> <status>LOCKED</status> <internalID>08000120080922115319000000000021</internalID> <externalID>7965_6</externalID> <channel>PAPER</channel> <function>UNSPECIFIED</function> <pageInfo>6/0</pageInfo> <documentTypeID>IMAGE_TIFF</documentTypeID> <mimeType>image/tiff</mimeType> <bytes>26431</bytes> <resourceLog> <created id="0" version="0"> <timeStamp>2008-09-22T11:54:47</timeStamp> </created> <collected id="0" version="0"> <timeStamp>2008-05-15T03:07:49</timeStamp> </collected> <loaded id="0" version="0"> <timeStamp>2008-09-22T11:54:47</timeStamp> </loaded> </resourceLog> </resourceEntry> </observationContext>
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________ Sedna-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sedna-discussion
