Sending multiple rows to the Database from an Application: Part II

  • First of all thanks to every one for putting your valuable comment.


    Jack Corbett (8/25/2009)


    lafleurh (8/25/2009)


    In the theoretical sense, it should not be necessary to insert multiple rows in one command (as stated above). But in the practical sense, we have had to do this. The number of round trips to the database (for us) greatly affected performance.

    Our technique (for MS SQL Server and Oracle) is not discussed here. We generate Insert statements and concatenate them into a string and execute them using an ADO.NET command object. It reduces the number of round trips to one--and it works.

    Sure that will work, but it also opens up the server (SQL Server and Oracle) for SQL Injection. What are you doing to reduce that risk?

    I just wanted to add one more point, the application where we implemented these techniques is mainly using JAVA family technology and data can only be handled through SP no Inline query .


    Pmohan: Thanks and good to see that someone get benefitted.:-)


    mbrunton

    I'm not sure that is true. We use varchar(MAX) to pass comma delimited strings. I believe these are up to 2GB

    No, even if you use varchar(max). It will hold 4000 / 8000 characters max including the delimiter character.

    Please check the Part-I forum, where I posted the testing script.

  • Max Minkov (8/25/2009)


    Very insightful article!

    INSERT

    INTO [AddressBook]

    ([LastName], [FirstName],[Address])

    SELECT

    T.Item.query('./LastName').value('.', 'VARCHAR(25)') [LastName],

    T.Item.query('./FirstName').value('.', 'VARCHAR(25)') [FirstName],

    T.Item.query('./Address').value('.', 'AddressInfo') [Address],

    FROM @xmlAddressBook.nodes('/AddressBook/Contact') AS T(Item)

    You can use the following SQL syntax.

    SELECT

    T.Item.query('./LASTNAME').value('.', 'VARCHAR(25)') [LastName],

    T.Item.query('./FIRSTNAME').value('.', 'VARCHAR(25)') [FirstName],

    T.Item.query('./ADDRESS/STREET').value('.', 'Varchar(20)') + ','

    + T.Item.query('./ADDRESS/CITY').value('.', 'Varchar(20)') + ','

    + T.Item.query('./ADDRESS/STATE').value('.', 'Varchar(20)') [Address]

    FROM @xmlAddressBook.nodes('/ADDRESSBOOK/CONTACT') AS T(Item)

    Hope, you could have a Parse function in your CLR type defined, which takes a string type as an parameter and in the function you split the string. Hope you are using the delimiter as "," in the Parse function. (Plese check).

    The same delimiter , you have to add in SELECT + ',' , which you are using in the Parse method.

    hope this could help you to solve your problem.

  • Hope, you could have a Parse function in your CLR type defined, which takes a string type as an parameter and in the function you split the string. Hope you are using the delimiter as "," in the Parse function. (Plese check).

    The same delimiter , you have to add in SELECT + ',' , which you are using in the Parse method.

    hope this could help you to solve your problem.

    Thank you very much that did it!

  • I have used XML to insert multiple rows using a SP for years now. I certainly see the benefits. There is a huge performance boost when inserting data aggregations that need to be placed in multiple related tables. You just hand over a big chunk of XML to the SP, and it can handle all the inserts within a single transaction. The code is not that complex. It usually just boils down to a set of 'INSERT INTO ... SELECT FROM ..' statements.

  • dewit.john (8/27/2009)


    I have used XML to insert multiple rows using a SP for years now. .... The code is not that complex. It usually just boils down to a set of 'INSERT INTO ... SELECT FROM ..' statements.

    Thanks John.

  • I've written a fair number of blog articles around SQL XML. The query methodologies you've chosen to use within SQL Server are actually less than performance-minded. As odd as it seems, it's actually better (performance-wise) to start iterating from the top down the hierarchy to create your results sets using CROSS APPLY rather than driving the query off of the logical "row". I'll try to post some examples on my blog if I have time soon.

    http://blog.scoftware.com/?tag=/sql-xml

    Jeff

  • check execution plan of the original query and this one

    SELECT T.Item.value('Name[1]', 'VARCHAR(50)') Name,

    T.Item.value('Salary[1]', 'INT') Salary

    FROM @xml.nodes('/ROWS/ROW') AS T(Item)

  • Vladimir.Moldovanenko@2020.net (8/28/2009)


    check execution plan of the original query and this one

    SELECT T.Item.value('Name[1]', 'VARCHAR(50)') Name,

    T.Item.value('Salary[1]', 'INT') Salary

    FROM @xml.nodes('/ROWS/ROW') AS T(Item)

    Thanks for your post.

    Yes I checked and found that your query is talking 55% in compare to original query, which is talking 45% only. You can check execution plan of below code.

    Declare @xmlXML

    SET @xml = N'

    '

    SELECT T.Item.value('Name[1]', 'VARCHAR(50)') Name,

    T.Item.value('Salary[1]', 'INT') Salary

    FROM @xml.nodes('/ROWS/ROW') AS T(Item)

    SELECT T.Item.value('@Name', 'VARCHAR(50)') Name,

    T.Item.value('@Salary', 'INT') Salary

    FROM @xml.nodes('/ROWS/ROW') AS T(Item)

    BTW, this topic I posted to share the approach how can we update multiple rows using SP. so not considered much about the X-Query optimization.

  • dewit.john (8/27/2009)


    I have used XML to insert multiple rows using a SP for years now. I certainly see the benefits. There is a huge performance boost when inserting data aggregations that need to be placed in multiple related tables. You just hand over a big chunk of XML to the SP, and it can handle all the inserts within a single transaction.

    You do not have to commit every statement you send to the database!

    I do believe all this makes sense only if the database is somewhere a long way off and the network delay slows things more than the additional work on both the client and the server. If it's on the same computer or just next to each other in the rack, you'd better prepare the statements and then shoot the server a row of "call prepared statement number 2 with these parameters" requests committing either when you're done or after a predetermined number of rows.

    Of course if you commit each row and you send the server ad-hoc insert/update statements forcing it to parse the SQL over and over again, this will be a big improvement.

  • which one would be better in performance to use this approach, use openxml or use the Bulk Load of xml? i have to do an insert/update of around 450,000 rows daily from a xml file.

  • From my personal experience, parsing XML using nodes() is OK if you do not travel axes (../). You just need to write it properly.

    For very huge files, OPENXML will do better. Yet, I would start with nodes() as OPENXML is being deprecated.

    For example, compare below statements.

    -- http://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist-90d.xml

    DECLARE @x XML =

    '<?xml version="1.0" encoding="UTF-8"?><gesmes:Envelope

    xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01"

    xmlns="http://www.ecb.int/vocabulary/2002-08-01/eurofxref"><gesmes:subject>Reference

    rates</gesmes:subject><gesmes:Sender><gesmes:name>European Central

    Bank</gesmes:name></gesmes:Sender><Cube><Cube time="2009-09-09"><Cube

    currency="USD" rate="1.4522"/><Cube currency="JPY" rate="134.13"/><Cube

    currency="BGN" rate="1.9558"/><Cube currency="CZK" rate="25.522"/><Cube

    currency="DKK" rate="7.4437"/><Cube currency="EEK" rate="15.6466"/><Cube

    currency="GBP" rate="0.8793"/><Cube currency="HUF" rate="271.25"/><Cube

    currency="LTL" rate="3.4528"/><Cube currency="LVL" rate="0.7024"/><Cube

    currency="PLN" rate="4.124"/><Cube currency="RON" rate="4.2488"/><Cube

    currency="SEK" rate="10.2308"/><Cube currency="CHF" rate="1.5173"/><Cube

    currency="NOK" rate="8.611"/><Cube currency="HRK" rate="7.3457"/><Cube

    currency="RUB" rate="45.2"/><Cube currency="TRY" rate="2.166"/><Cube

    currency="AUD" rate="1.6836"/><Cube currency="BRL" rate="2.6497"/><Cube

    currency="CAD" rate="1.569"/><Cube currency="CNY" rate="9.9168"/><Cube

    currency="HKD" rate="11.255"/><Cube currency="IDR" rate="14411.86"/><Cube

    currency="INR" rate="70.432"/><Cube currency="KRW" rate="1781.61"/><Cube

    currency="MXN" rate="19.3687"/><Cube currency="MYR" rate="5.0776"/><Cube

    currency="NZD" rate="2.0819"/><Cube currency="PHP" rate="70.297"/><Cube

    currency="SGD" rate="2.0698"/><Cube currency="THB" rate="49.397"/><Cube

    currency="ZAR" rate="10.9518"/></Cube>

    <Cube time="2009-09-08"><Cube currency="USD" rate="1.4473"/><Cube

    currency="JPY" rate="133.57"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.479"/><Cube currency="DKK" rate="7.4438"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.87365"/><Cube

    currency="HUF" rate="270.98"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7021"/><Cube currency="PLN" rate="4.0893"/><Cube

    currency="RON" rate="4.2412"/><Cube currency="SEK" rate="10.1867"/><Cube

    currency="CHF" rate="1.5159"/><Cube currency="NOK" rate="8.569"/><Cube

    currency="HRK" rate="7.3414"/><Cube currency="RUB" rate="45.37"/><Cube

    currency="TRY" rate="2.1521"/><Cube currency="AUD" rate="1.677"/><Cube

    currency="BRL" rate="2.6436"/><Cube currency="CAD" rate="1.5483"/><Cube

    currency="CNY" rate="9.8814"/><Cube currency="HKD" rate="11.2169"/><Cube

    currency="IDR" rate="14458.52"/><Cube currency="INR" rate="70.114"/><Cube

    currency="KRW" rate="1783.31"/><Cube currency="MXN" rate="19.2419"/><Cube

    currency="MYR" rate="5.0684"/><Cube currency="NZD" rate="2.079"/><Cube

    currency="PHP" rate="69.979"/><Cube currency="SGD" rate="2.0644"/><Cube

    currency="THB" rate="49.244"/><Cube currency="ZAR" rate="10.9076"/></Cube>

    <Cube time="2009-09-07"><Cube currency="USD" rate="1.433"/><Cube

    currency="JPY" rate="133.33"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.488"/><Cube currency="DKK" rate="7.4435"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8735"/><Cube

    currency="HUF" rate="272.24"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.702"/><Cube currency="PLN" rate="4.11"/><Cube

    currency="RON" rate="4.2463"/><Cube currency="SEK" rate="10.1955"/><Cube

    currency="CHF" rate="1.5181"/><Cube currency="NOK" rate="8.585"/><Cube

    currency="HRK" rate="7.3365"/><Cube currency="RUB" rate="45.1005"/><Cube

    currency="TRY" rate="2.1374"/><Cube currency="AUD" rate="1.6748"/><Cube

    currency="BRL" rate="2.6419"/><Cube currency="CAD" rate="1.5429"/><Cube

    currency="CNY" rate="9.786"/><Cube currency="HKD" rate="11.1064"/><Cube

    currency="IDR" rate="14417.23"/><Cube currency="INR" rate="69.73"/><Cube

    currency="KRW" rate="1768.23"/><Cube currency="MXN" rate="19.1843"/><Cube

    currency="MYR" rate="5.037"/><Cube currency="NZD" rate="2.0696"/><Cube

    currency="PHP" rate="69.677"/><Cube currency="SGD" rate="2.0536"/><Cube

    currency="THB" rate="48.784"/><Cube currency="ZAR" rate="10.87"/></Cube>

    <Cube time="2009-09-04"><Cube currency="USD" rate="1.4262"/><Cube

    currency="JPY" rate="132.45"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.561"/><Cube currency="DKK" rate="7.4436"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.872"/><Cube

    currency="HUF" rate="274.35"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7023"/><Cube currency="PLN" rate="4.1145"/><Cube

    currency="RON" rate="4.2468"/><Cube currency="SEK" rate="10.2844"/><Cube

    currency="CHF" rate="1.5157"/><Cube currency="NOK" rate="8.608"/><Cube

    currency="HRK" rate="7.3334"/><Cube currency="RUB" rate="45.1308"/><Cube

    currency="TRY" rate="2.142"/><Cube currency="AUD" rate="1.6915"/><Cube

    currency="BRL" rate="2.6469"/><Cube currency="CAD" rate="1.5581"/><Cube

    currency="CNY" rate="9.7409"/><Cube currency="HKD" rate="11.0533"/><Cube

    currency="IDR" rate="14426.36"/><Cube currency="INR" rate="69.727"/><Cube

    currency="KRW" rate="1769.09"/><Cube currency="MXN" rate="19.3072"/><Cube

    currency="MYR" rate="5.0281"/><Cube currency="NZD" rate="2.0851"/><Cube

    currency="PHP" rate="69.337"/><Cube currency="SGD" rate="2.0517"/><Cube

    currency="THB" rate="48.597"/><Cube currency="ZAR" rate="10.9136"/></Cube>

    <Cube time="2009-09-03"><Cube currency="USD" rate="1.4335"/><Cube

    currency="JPY" rate="132.47"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.615"/><Cube currency="DKK" rate="7.4438"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8747"/><Cube

    currency="HUF" rate="273.95"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7027"/><Cube currency="PLN" rate="4.121"/><Cube

    currency="RON" rate="4.2405"/><Cube currency="SEK" rate="10.3138"/><Cube

    currency="CHF" rate="1.5143"/><Cube currency="NOK" rate="8.62"/><Cube

    currency="HRK" rate="7.3455"/><Cube currency="RUB" rate="45.34"/><Cube

    currency="TRY" rate="2.1549"/><Cube currency="AUD" rate="1.7037"/><Cube

    currency="BRL" rate="2.678"/><Cube currency="CAD" rate="1.5742"/><Cube

    currency="CNY" rate="9.7915"/><Cube currency="HKD" rate="11.1108"/><Cube

    currency="IDR" rate="14493.04"/><Cube currency="INR" rate="70.12"/><Cube

    currency="KRW" rate="1784.75"/><Cube currency="MXN" rate="19.412"/><Cube

    currency="MYR" rate="5.0574"/><Cube currency="NZD" rate="2.1025"/><Cube

    currency="PHP" rate="69.824"/><Cube currency="SGD" rate="2.062"/><Cube

    currency="THB" rate="48.817"/><Cube currency="ZAR" rate="11.1046"/></Cube>

    <Cube time="2009-09-02"><Cube currency="USD" rate="1.422"/><Cube

    currency="JPY" rate="131.63"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.686"/><Cube currency="DKK" rate="7.4428"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8751"/><Cube

    currency="HUF" rate="276.37"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7028"/><Cube currency="PLN" rate="4.168"/><Cube

    currency="RON" rate="4.2388"/><Cube currency="SEK" rate="10.3186"/><Cube

    currency="CHF" rate="1.5167"/><Cube currency="NOK" rate="8.68"/><Cube

    currency="HRK" rate="7.3461"/><Cube currency="RUB" rate="45.3921"/><Cube

    currency="TRY" rate="2.1512"/><Cube currency="AUD" rate="1.7112"/><Cube

    currency="BRL" rate="2.7048"/><Cube currency="CAD" rate="1.572"/><Cube

    currency="CNY" rate="9.7137"/><Cube currency="HKD" rate="11.0222"/><Cube

    currency="IDR" rate="14450.56"/><Cube currency="INR" rate="69.642"/><Cube

    currency="KRW" rate="1774.54"/><Cube currency="MXN" rate="19.3961"/><Cube

    currency="MYR" rate="5.0332"/><Cube currency="NZD" rate="2.1078"/><Cube

    currency="PHP" rate="69.534"/><Cube currency="SGD" rate="2.0526"/><Cube

    currency="THB" rate="48.426"/><Cube currency="ZAR" rate="11.1879"/></Cube>

    <Cube time="2009-09-01"><Cube currency="USD" rate="1.4314"/><Cube

    currency="JPY" rate="133.26"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.567"/><Cube currency="DKK" rate="7.4432"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8815"/><Cube

    currency="HUF" rate="273.65"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.703"/><Cube currency="PLN" rate="4.1088"/><Cube

    currency="RON" rate="4.2278"/><Cube currency="SEK" rate="10.22"/><Cube

    currency="CHF" rate="1.5153"/><Cube currency="NOK" rate="8.612"/><Cube

    currency="HRK" rate="7.35"/><Cube currency="RUB" rate="45.5685"/><Cube

    currency="TRY" rate="2.1558"/><Cube currency="AUD" rate="1.7096"/><Cube

    currency="BRL" rate="2.6914"/><Cube currency="CAD" rate="1.5672"/><Cube

    currency="CNY" rate="9.777"/><Cube currency="HKD" rate="11.0939"/><Cube

    currency="IDR" rate="14477.49"/><Cube currency="INR" rate="70.139"/><Cube

    currency="KRW" rate="1776.87"/><Cube currency="MXN" rate="19.2344"/><Cube

    currency="MYR" rate="5.0485"/><Cube currency="NZD" rate="2.0953"/><Cube

    currency="PHP" rate="69.773"/><Cube currency="SGD" rate="2.0644"/><Cube

    currency="THB" rate="48.685"/><Cube currency="ZAR" rate="11.1649"/></Cube>

    <Cube time="2009-08-31"><Cube currency="USD" rate="1.4272"/><Cube

    currency="JPY" rate="133.1"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.376"/><Cube currency="DKK" rate="7.4431"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.88135"/><Cube

    currency="HUF" rate="271.85"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7031"/><Cube currency="PLN" rate="4.104"/><Cube

    currency="RON" rate="4.2238"/><Cube currency="SEK" rate="10.2191"/><Cube

    currency="CHF" rate="1.5168"/><Cube currency="NOK" rate="8.607"/><Cube

    currency="HRK" rate="7.364"/><Cube currency="RUB" rate="45.4645"/><Cube

    currency="TRY" rate="2.148"/><Cube currency="AUD" rate="1.7087"/><Cube

    currency="BRL" rate="2.7089"/><Cube currency="CAD" rate="1.5793"/><Cube

    currency="CNY" rate="9.7486"/><Cube currency="HKD" rate="11.062"/><Cube

    currency="IDR" rate="14390.15"/><Cube currency="INR" rate="69.79"/><Cube

    currency="KRW" rate="1783.28"/><Cube currency="MXN" rate="19.0246"/><Cube

    currency="MYR" rate="5.0259"/><Cube currency="NZD" rate="2.0973"/><Cube

    currency="PHP" rate="69.667"/><Cube currency="SGD" rate="2.0602"/><Cube

    currency="THB" rate="48.532"/><Cube currency="ZAR" rate="11.1136"/></Cube>

    <Cube time="2009-08-28"><Cube currency="USD" rate="1.4364"/><Cube

    currency="JPY" rate="134.75"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.42"/><Cube currency="DKK" rate="7.4432"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8784"/><Cube

    currency="HUF" rate="270.74"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7035"/><Cube currency="PLN" rate="4.087"/><Cube

    currency="RON" rate="4.217"/><Cube currency="SEK" rate="10.148"/><Cube

    currency="CHF" rate="1.517"/><Cube currency="NOK" rate="8.629"/><Cube

    currency="HRK" rate="7.358"/><Cube currency="RUB" rate="45.3466"/><Cube

    currency="TRY" rate="2.1532"/><Cube currency="AUD" rate="1.6995"/><Cube

    currency="BRL" rate="2.6731"/><Cube currency="CAD" rate="1.5522"/><Cube

    currency="CNY" rate="9.8108"/><Cube currency="HKD" rate="11.1335"/><Cube

    currency="IDR" rate="14435.32"/><Cube currency="INR" rate="69.895"/><Cube

    currency="KRW" rate="1786.57"/><Cube currency="MXN" rate="19.0179"/><Cube

    currency="MYR" rate="5.0583"/><Cube currency="NZD" rate="2.0908"/><Cube

    currency="PHP" rate="70.092"/><Cube currency="SGD" rate="2.0672"/><Cube

    currency="THB" rate="48.861"/><Cube currency="ZAR" rate="11.1376"/></Cube>

    <Cube time="2009-08-27"><Cube currency="USD" rate="1.4268"/><Cube

    currency="JPY" rate="133.61"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.406"/><Cube currency="DKK" rate="7.4436"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8804"/><Cube

    currency="HUF" rate="268.5"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7035"/><Cube currency="PLN" rate="4.1125"/><Cube

    currency="RON" rate="4.223"/><Cube currency="SEK" rate="10.1615"/><Cube

    currency="CHF" rate="1.5234"/><Cube currency="NOK" rate="8.644"/><Cube

    currency="HRK" rate="7.323"/><Cube currency="RUB" rate="45.1935"/><Cube

    currency="TRY" rate="2.1431"/><Cube currency="AUD" rate="1.7101"/><Cube

    currency="BRL" rate="2.6493"/><Cube currency="CAD" rate="1.5598"/><Cube

    currency="CNY" rate="9.7479"/><Cube currency="HKD" rate="11.059"/><Cube

    currency="IDR" rate="14506.97"/><Cube currency="INR" rate="69.792"/><Cube

    currency="KRW" rate="1780.15"/><Cube currency="MXN" rate="18.753"/><Cube

    currency="MYR" rate="5.0416"/><Cube currency="NZD" rate="2.0902"/><Cube

    currency="PHP" rate="69.734"/><Cube currency="SGD" rate="2.0598"/><Cube

    currency="THB" rate="48.547"/><Cube currency="ZAR" rate="11.202"/></Cube>

    <Cube time="2009-08-26"><Cube currency="USD" rate="1.427"/><Cube

    currency="JPY" rate="134.32"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.4"/><Cube currency="DKK" rate="7.4425"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.878"/><Cube

    currency="HUF" rate="267.7"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.702"/><Cube currency="PLN" rate="4.0933"/><Cube

    currency="RON" rate="4.221"/><Cube currency="SEK" rate="10.1445"/><Cube

    currency="CHF" rate="1.5189"/><Cube currency="NOK" rate="8.624"/><Cube

    currency="HRK" rate="7.32"/><Cube currency="RUB" rate="44.9315"/><Cube

    currency="TRY" rate="2.1472"/><Cube currency="AUD" rate="1.7163"/><Cube

    currency="BRL" rate="2.6619"/><Cube currency="CAD" rate="1.557"/><Cube

    currency="CNY" rate="9.748"/><Cube currency="HKD" rate="11.0601"/><Cube

    currency="IDR" rate="14406.62"/><Cube currency="INR" rate="69.773"/><Cube

    currency="KRW" rate="1779.74"/><Cube currency="MXN" rate="18.5867"/><Cube

    currency="MYR" rate="5.0287"/><Cube currency="NZD" rate="2.0879"/><Cube

    currency="PHP" rate="69.543"/><Cube currency="SGD" rate="2.0597"/><Cube

    currency="THB" rate="48.525"/><Cube currency="ZAR" rate="11.2092"/></Cube>

    <Cube time="2009-08-25"><Cube currency="USD" rate="1.4324"/><Cube

    currency="JPY" rate="135.05"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.356"/><Cube currency="DKK" rate="7.4429"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.87405"/><Cube

    currency="HUF" rate="266.96"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6998"/><Cube currency="PLN" rate="4.0806"/><Cube

    currency="RON" rate="4.221"/><Cube currency="SEK" rate="10.0895"/><Cube

    currency="CHF" rate="1.5171"/><Cube currency="NOK" rate="8.6095"/><Cube

    currency="HRK" rate="7.3203"/><Cube currency="RUB" rate="44.9399"/><Cube

    currency="TRY" rate="2.1351"/><Cube currency="AUD" rate="1.7054"/><Cube

    currency="BRL" rate="2.6293"/><Cube currency="CAD" rate="1.5411"/><Cube

    currency="CNY" rate="9.7859"/><Cube currency="HKD" rate="11.1015"/><Cube

    currency="IDR" rate="14359.3"/><Cube currency="INR" rate="69.837"/><Cube

    currency="KRW" rate="1786.44"/><Cube currency="MXN" rate="18.4851"/><Cube

    currency="MYR" rate="5.0413"/><Cube currency="NZD" rate="2.0832"/><Cube

    currency="PHP" rate="69.3"/><Cube currency="SGD" rate="2.0655"/><Cube

    currency="THB" rate="48.723"/><Cube currency="ZAR" rate="11.1739"/></Cube>

    <Cube time="2009-08-24"><Cube currency="USD" rate="1.4323"/><Cube

    currency="JPY" rate="135.57"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.44"/><Cube currency="DKK" rate="7.4431"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8682"/><Cube

    currency="HUF" rate="268.15"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7005"/><Cube currency="PLN" rate="4.1123"/><Cube

    currency="RON" rate="4.222"/><Cube currency="SEK" rate="10.1046"/><Cube

    currency="CHF" rate="1.5184"/><Cube currency="NOK" rate="8.5845"/><Cube

    currency="HRK" rate="7.3228"/><Cube currency="RUB" rate="45.041"/><Cube

    currency="TRY" rate="2.1261"/><Cube currency="AUD" rate="1.7032"/><Cube

    currency="BRL" rate="2.6168"/><Cube currency="CAD" rate="1.5444"/><Cube

    currency="CNY" rate="9.7845"/><Cube currency="HKD" rate="11.1013"/><Cube

    currency="IDR" rate="14331.16"/><Cube currency="INR" rate="69.631"/><Cube

    currency="KRW" rate="1778.25"/><Cube currency="MXN" rate="18.3342"/><Cube

    currency="MYR" rate="5.0267"/><Cube currency="NZD" rate="2.0865"/><Cube

    currency="PHP" rate="69.28"/><Cube currency="SGD" rate="2.0633"/><Cube

    currency="THB" rate="48.713"/><Cube currency="ZAR" rate="11.1195"/></Cube>

    <Cube time="2009-08-21"><Cube currency="USD" rate="1.433"/><Cube

    currency="JPY" rate="134.19"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.482"/><Cube currency="DKK" rate="7.4435"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8657"/><Cube

    currency="HUF" rate="268.59"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6998"/><Cube currency="PLN" rate="4.1068"/><Cube

    currency="RON" rate="4.224"/><Cube currency="SEK" rate="10.1432"/><Cube

    currency="CHF" rate="1.516"/><Cube currency="NOK" rate="8.555"/><Cube

    currency="HRK" rate="7.3083"/><Cube currency="RUB" rate="45.39"/><Cube

    currency="TRY" rate="2.1324"/><Cube currency="AUD" rate="1.7197"/><Cube

    currency="BRL" rate="2.6289"/><Cube currency="CAD" rate="1.5541"/><Cube

    currency="CNY" rate="9.7891"/><Cube currency="HKD" rate="11.1074"/><Cube

    currency="IDR" rate="14352.49"/><Cube currency="INR" rate="69.687"/><Cube

    currency="KRW" rate="1788.62"/><Cube currency="MXN" rate="18.3954"/><Cube

    currency="MYR" rate="5.0456"/><Cube currency="NZD" rate="2.1015"/><Cube

    currency="PHP" rate="69.378"/><Cube currency="SGD" rate="2.062"/><Cube

    currency="THB" rate="48.765"/><Cube currency="ZAR" rate="11.2261"/></Cube>

    <Cube time="2009-08-20"><Cube currency="USD" rate="1.4243"/><Cube

    currency="JPY" rate="134.11"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.585"/><Cube currency="DKK" rate="7.4436"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8638"/><Cube

    currency="HUF" rate="271.5"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6993"/><Cube currency="PLN" rate="4.152"/><Cube

    currency="RON" rate="4.2335"/><Cube currency="SEK" rate="10.1977"/><Cube

    currency="CHF" rate="1.5169"/><Cube currency="NOK" rate="8.5955"/><Cube

    currency="HRK" rate="7.332"/><Cube currency="RUB" rate="45.22"/><Cube

    currency="TRY" rate="2.125"/><Cube currency="AUD" rate="1.7124"/><Cube

    currency="BRL" rate="2.6194"/><Cube currency="CAD" rate="1.56"/><Cube

    currency="CNY" rate="9.7305"/><Cube currency="HKD" rate="11.0398"/><Cube

    currency="IDR" rate="14326.89"/><Cube currency="INR" rate="69.371"/><Cube

    currency="KRW" rate="1777.5"/><Cube currency="MXN" rate="18.2733"/><Cube

    currency="MYR" rate="5.0228"/><Cube currency="NZD" rate="2.1055"/><Cube

    currency="PHP" rate="68.964"/><Cube currency="SGD" rate="2.0617"/><Cube

    currency="THB" rate="48.462"/><Cube currency="ZAR" rate="11.3161"/></Cube>

    <Cube time="2009-08-19"><Cube currency="USD" rate="1.4112"/><Cube

    currency="JPY" rate="132.55"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.711"/><Cube currency="DKK" rate="7.4433"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8608"/><Cube

    currency="HUF" rate="274.41"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7003"/><Cube currency="PLN" rate="4.1935"/><Cube

    currency="RON" rate="4.2288"/><Cube currency="SEK" rate="10.2585"/><Cube

    currency="CHF" rate="1.5152"/><Cube currency="NOK" rate="8.67"/><Cube

    currency="HRK" rate="7.3185"/><Cube currency="RUB" rate="45.056"/><Cube

    currency="TRY" rate="2.1285"/><Cube currency="AUD" rate="1.7239"/><Cube

    currency="BRL" rate="2.6237"/><Cube currency="CAD" rate="1.5657"/><Cube

    currency="CNY" rate="9.6443"/><Cube currency="HKD" rate="10.9397"/><Cube

    currency="IDR" rate="14296.39"/><Cube currency="INR" rate="68.86"/><Cube

    currency="KRW" rate="1775.37"/><Cube currency="MXN" rate="18.3202"/><Cube

    currency="MYR" rate="5.0048"/><Cube currency="NZD" rate="2.1108"/><Cube

    currency="PHP" rate="68.442"/><Cube currency="SGD" rate="2.0494"/><Cube

    currency="THB" rate="48.058"/><Cube currency="ZAR" rate="11.424"/></Cube>

    <Cube time="2009-08-18"><Cube currency="USD" rate="1.4101"/><Cube

    currency="JPY" rate="134.12"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.568"/><Cube currency="DKK" rate="7.4433"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8566"/><Cube

    currency="HUF" rate="272.66"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7002"/><Cube currency="PLN" rate="4.1645"/><Cube

    currency="RON" rate="4.2188"/><Cube currency="SEK" rate="10.2375"/><Cube

    currency="CHF" rate="1.5207"/><Cube currency="NOK" rate="8.6735"/><Cube

    currency="HRK" rate="7.3093"/><Cube currency="RUB" rate="45.105"/><Cube

    currency="TRY" rate="2.1117"/><Cube currency="AUD" rate="1.7116"/><Cube

    currency="BRL" rate="2.6281"/><Cube currency="CAD" rate="1.5606"/><Cube

    currency="CNY" rate="9.6365"/><Cube currency="HKD" rate="10.9302"/><Cube

    currency="IDR" rate="14133"/><Cube currency="INR" rate="68.806"/><Cube

    currency="KRW" rate="1762.49"/><Cube currency="MXN" rate="18.2467"/><Cube

    currency="MYR" rate="4.9882"/><Cube currency="NZD" rate="2.0985"/><Cube

    currency="PHP" rate="68.047"/><Cube currency="SGD" rate="2.045"/><Cube

    currency="THB" rate="48.021"/><Cube currency="ZAR" rate="11.345"/></Cube>

    <Cube time="2009-08-17"><Cube currency="USD" rate="1.4072"/><Cube

    currency="JPY" rate="132.94"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.785"/><Cube currency="DKK" rate="7.4435"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8629"/><Cube

    currency="HUF" rate="274.07"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.198"/><Cube

    currency="RON" rate="4.2245"/><Cube currency="SEK" rate="10.288"/><Cube

    currency="CHF" rate="1.5212"/><Cube currency="NOK" rate="8.7265"/><Cube

    currency="HRK" rate="7.3027"/><Cube currency="RUB" rate="45.48"/><Cube

    currency="TRY" rate="2.1222"/><Cube currency="AUD" rate="1.7208"/><Cube

    currency="BRL" rate="2.6396"/><Cube currency="CAD" rate="1.5621"/><Cube

    currency="CNY" rate="9.6203"/><Cube currency="HKD" rate="10.9068"/><Cube

    currency="IDR" rate="14119.06"/><Cube currency="INR" rate="68.812"/><Cube

    currency="KRW" rate="1771.04"/><Cube currency="MXN" rate="18.3075"/><Cube

    currency="MYR" rate="4.985"/><Cube currency="NZD" rate="2.1155"/><Cube

    currency="PHP" rate="68.076"/><Cube currency="SGD" rate="2.0434"/><Cube

    currency="THB" rate="47.95"/><Cube currency="ZAR" rate="11.5338"/></Cube>

    <Cube time="2009-08-14"><Cube currency="USD" rate="1.4294"/><Cube

    currency="JPY" rate="135.61"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.733"/><Cube currency="DKK" rate="7.4444"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8616"/><Cube

    currency="HUF" rate="269.2"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.124"/><Cube

    currency="RON" rate="4.213"/><Cube currency="SEK" rate="10.1835"/><Cube

    currency="CHF" rate="1.5267"/><Cube currency="NOK" rate="8.6165"/><Cube

    currency="HRK" rate="7.312"/><Cube currency="RUB" rate="45.12"/><Cube

    currency="TRY" rate="2.116"/><Cube currency="AUD" rate="1.6939"/><Cube

    currency="BRL" rate="2.602"/><Cube currency="CAD" rate="1.5509"/><Cube

    currency="CNY" rate="9.7688"/><Cube currency="HKD" rate="11.0784"/><Cube

    currency="IDR" rate="14246.96"/><Cube currency="INR" rate="68.961"/><Cube

    currency="KRW" rate="1769.06"/><Cube currency="MXN" rate="18.3544"/><Cube

    currency="MYR" rate="5.0279"/><Cube currency="NZD" rate="2.0785"/><Cube

    currency="PHP" rate="68.695"/><Cube currency="SGD" rate="2.0628"/><Cube

    currency="THB" rate="48.635"/><Cube currency="ZAR" rate="11.5152"/></Cube>

    <Cube time="2009-08-13"><Cube currency="USD" rate="1.4293"/><Cube

    currency="JPY" rate="137.52"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.738"/><Cube currency="DKK" rate="7.4447"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85865"/><Cube

    currency="HUF" rate="268.21"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7008"/><Cube currency="PLN" rate="4.1085"/><Cube

    currency="RON" rate="4.215"/><Cube currency="SEK" rate="10.196"/><Cube

    currency="CHF" rate="1.5328"/><Cube currency="NOK" rate="8.608"/><Cube

    currency="HRK" rate="7.3245"/><Cube currency="RUB" rate="45.412"/><Cube

    currency="TRY" rate="2.1056"/><Cube currency="AUD" rate="1.6931"/><Cube

    currency="BRL" rate="2.6029"/><Cube currency="CAD" rate="1.5451"/><Cube

    currency="CNY" rate="9.7674"/><Cube currency="HKD" rate="11.0786"/><Cube

    currency="IDR" rate="14225.1"/><Cube currency="INR" rate="68.692"/><Cube

    currency="KRW" rate="1759.41"/><Cube currency="MXN" rate="18.3544"/><Cube

    currency="MYR" rate="5.0147"/><Cube currency="NZD" rate="2.1021"/><Cube

    currency="PHP" rate="68.495"/><Cube currency="SGD" rate="2.0599"/><Cube

    currency="THB" rate="48.664"/><Cube currency="ZAR" rate="11.369"/></Cube>

    <Cube time="2009-08-12"><Cube currency="USD" rate="1.417"/><Cube

    currency="JPY" rate="135.77"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.768"/><Cube currency="DKK" rate="7.4445"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85965"/><Cube

    currency="HUF" rate="273.6"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.701"/><Cube currency="PLN" rate="4.1813"/><Cube

    currency="RON" rate="4.2218"/><Cube currency="SEK" rate="10.2656"/><Cube

    currency="CHF" rate="1.5276"/><Cube currency="NOK" rate="8.7325"/><Cube

    currency="HRK" rate="7.3259"/><Cube currency="RUB" rate="46.09"/><Cube

    currency="TRY" rate="2.1267"/><Cube currency="AUD" rate="1.7201"/><Cube

    currency="BRL" rate="2.6176"/><Cube currency="CAD" rate="1.5633"/><Cube

    currency="CNY" rate="9.6853"/><Cube currency="HKD" rate="10.9828"/><Cube

    currency="IDR" rate="14162.71"/><Cube currency="INR" rate="68.533"/><Cube

    currency="KRW" rate="1767.31"/><Cube currency="MXN" rate="18.52"/><Cube

    currency="MYR" rate="5.0027"/><Cube currency="NZD" rate="2.1294"/><Cube

    currency="PHP" rate="68.102"/><Cube currency="SGD" rate="2.0509"/><Cube

    currency="THB" rate="48.277"/><Cube currency="ZAR" rate="11.5202"/></Cube>

    <Cube time="2009-08-11"><Cube currency="USD" rate="1.4166"/><Cube

    currency="JPY" rate="136.72"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.77"/><Cube currency="DKK" rate="7.4449"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8584"/><Cube

    currency="HUF" rate="273.1"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7011"/><Cube currency="PLN" rate="4.174"/><Cube

    currency="RON" rate="4.2163"/><Cube currency="SEK" rate="10.3486"/><Cube

    currency="CHF" rate="1.5301"/><Cube currency="NOK" rate="8.8265"/><Cube

    currency="HRK" rate="7.3224"/><Cube currency="RUB" rate="45.769"/><Cube

    currency="TRY" rate="2.1225"/><Cube currency="AUD" rate="1.6965"/><Cube

    currency="BRL" rate="2.6277"/><Cube currency="CAD" rate="1.5537"/><Cube

    currency="CNY" rate="9.6825"/><Cube currency="HKD" rate="10.9793"/><Cube

    currency="IDR" rate="14054.16"/><Cube currency="INR" rate="67.94"/><Cube

    currency="KRW" rate="1759.28"/><Cube currency="MXN" rate="18.3946"/><Cube

    currency="MYR" rate="4.973"/><Cube currency="NZD" rate="2.1126"/><Cube

    currency="PHP" rate="67.596"/><Cube currency="SGD" rate="2.0489"/><Cube

    currency="THB" rate="48.228"/><Cube currency="ZAR" rate="11.5304"/></Cube>

    <Cube time="2009-08-10"><Cube currency="USD" rate="1.4202"/><Cube

    currency="JPY" rate="138.01"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.678"/><Cube currency="DKK" rate="7.445"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85355"/><Cube

    currency="HUF" rate="269.31"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7006"/><Cube currency="PLN" rate="4.1154"/><Cube

    currency="RON" rate="4.2095"/><Cube currency="SEK" rate="10.2129"/><Cube

    currency="CHF" rate="1.5345"/><Cube currency="NOK" rate="8.694"/><Cube

    currency="HRK" rate="7.3269"/><Cube currency="RUB" rate="45.0035"/><Cube

    currency="TRY" rate="2.0929"/><Cube currency="AUD" rate="1.6895"/><Cube

    currency="BRL" rate="2.5813"/><Cube currency="CAD" rate="1.5361"/><Cube

    currency="CNY" rate="9.7062"/><Cube currency="HKD" rate="11.007"/><Cube

    currency="IDR" rate="14103.4"/><Cube currency="INR" rate="67.9"/><Cube

    currency="KRW" rate="1742.67"/><Cube currency="MXN" rate="18.3135"/><Cube

    currency="MYR" rate="4.9771"/><Cube currency="NZD" rate="2.0985"/><Cube

    currency="PHP" rate="67.729"/><Cube currency="SGD" rate="2.0468"/><Cube

    currency="THB" rate="48.322"/><Cube currency="ZAR" rate="11.4031"/></Cube>

    <Cube time="2009-08-07"><Cube currency="USD" rate="1.4357"/><Cube

    currency="JPY" rate="136.89"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.91"/><Cube currency="DKK" rate="7.4448"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8567"/><Cube

    currency="HUF" rate="272.8"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7023"/><Cube currency="PLN" rate="4.167"/><Cube

    currency="RON" rate="4.2168"/><Cube currency="SEK" rate="10.3008"/><Cube

    currency="CHF" rate="1.5288"/><Cube currency="NOK" rate="8.7515"/><Cube

    currency="HRK" rate="7.335"/><Cube currency="RUB" rate="45.445"/><Cube

    currency="TRY" rate="2.13"/><Cube currency="AUD" rate="1.7161"/><Cube

    currency="BRL" rate="2.6336"/><Cube currency="CAD" rate="1.554"/><Cube

    currency="CNY" rate="9.8084"/><Cube currency="HKD" rate="11.1272"/><Cube

    currency="IDR" rate="14308.44"/><Cube currency="INR" rate="68.576"/><Cube

    currency="KRW" rate="1761.67"/><Cube currency="MXN" rate="18.7072"/><Cube

    currency="MYR" rate="5.0257"/><Cube currency="NZD" rate="2.1315"/><Cube

    currency="PHP" rate="68.557"/><Cube currency="SGD" rate="2.0628"/><Cube

    currency="THB" rate="48.778"/><Cube currency="ZAR" rate="11.6875"/></Cube>

    <Cube time="2009-08-06"><Cube currency="USD" rate="1.437"/><Cube

    currency="JPY" rate="137.31"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.944"/><Cube currency="DKK" rate="7.445"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8524"/><Cube

    currency="HUF" rate="269.89"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7025"/><Cube currency="PLN" rate="4.145"/><Cube

    currency="RON" rate="4.2121"/><Cube currency="SEK" rate="10.2707"/><Cube

    currency="CHF" rate="1.529"/><Cube currency="NOK" rate="8.6635"/><Cube

    currency="HRK" rate="7.3359"/><Cube currency="RUB" rate="44.951"/><Cube

    currency="TRY" rate="2.122"/><Cube currency="AUD" rate="1.7067"/><Cube

    currency="BRL" rate="2.6129"/><Cube currency="CAD" rate="1.5416"/><Cube

    currency="CNY" rate="9.8164"/><Cube currency="HKD" rate="11.1369"/><Cube

    currency="IDR" rate="14275.85"/><Cube currency="INR" rate="68.401"/><Cube

    currency="KRW" rate="1759.06"/><Cube currency="MXN" rate="18.711"/><Cube

    currency="MYR" rate="5.0158"/><Cube currency="NZD" rate="2.1435"/><Cube

    currency="PHP" rate="68.626"/><Cube currency="SGD" rate="2.0632"/><Cube

    currency="THB" rate="48.833"/><Cube currency="ZAR" rate="11.585"/></Cube>

    <Cube time="2009-08-05"><Cube currency="USD" rate="1.441"/><Cube

    currency="JPY" rate="137.38"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.945"/><Cube currency="DKK" rate="7.445"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84695"/><Cube

    currency="HUF" rate="267"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7028"/><Cube currency="PLN" rate="4.1005"/><Cube

    currency="RON" rate="4.2045"/><Cube currency="SEK" rate="10.2683"/><Cube

    currency="CHF" rate="1.5316"/><Cube currency="NOK" rate="8.6685"/><Cube

    currency="HRK" rate="7.3383"/><Cube currency="RUB" rate="44.8946"/><Cube

    currency="TRY" rate="2.1019"/><Cube currency="AUD" rate="1.708"/><Cube

    currency="BRL" rate="2.6141"/><Cube currency="CAD" rate="1.5507"/><Cube

    currency="CNY" rate="9.8433"/><Cube currency="HKD" rate="11.1678"/><Cube

    currency="IDR" rate="14279.88"/><Cube currency="INR" rate="68.332"/><Cube

    currency="KRW" rate="1762.11"/><Cube currency="MXN" rate="18.9082"/><Cube

    currency="MYR" rate="5.0399"/><Cube currency="NZD" rate="2.1347"/><Cube

    currency="PHP" rate="68.976"/><Cube currency="SGD" rate="2.0653"/><Cube

    currency="THB" rate="48.98"/><Cube currency="ZAR" rate="11.3966"/></Cube>

    <Cube time="2009-08-04"><Cube currency="USD" rate="1.4384"/><Cube

    currency="JPY" rate="136.22"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.863"/><Cube currency="DKK" rate="7.4452"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84845"/><Cube

    currency="HUF" rate="267.05"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7025"/><Cube currency="PLN" rate="4.1233"/><Cube

    currency="RON" rate="4.2145"/><Cube currency="SEK" rate="10.3043"/><Cube

    currency="CHF" rate="1.5286"/><Cube currency="NOK" rate="8.704"/><Cube

    currency="HRK" rate="7.347"/><Cube currency="RUB" rate="44.842"/><Cube

    currency="TRY" rate="2.1091"/><Cube currency="AUD" rate="1.7116"/><Cube

    currency="BRL" rate="2.6393"/><Cube currency="CAD" rate="1.5369"/><Cube

    currency="CNY" rate="9.8246"/><Cube currency="HKD" rate="11.1477"/><Cube

    currency="IDR" rate="14208.64"/><Cube currency="INR" rate="68.439"/><Cube

    currency="KRW" rate="1753.18"/><Cube currency="MXN" rate="18.9279"/><Cube

    currency="MYR" rate="5.0265"/><Cube currency="NZD" rate="2.1609"/><Cube

    currency="PHP" rate="68.824"/><Cube currency="SGD" rate="2.0622"/><Cube

    currency="THB" rate="48.884"/><Cube currency="ZAR" rate="11.2817"/></Cube>

    <Cube time="2009-08-03"><Cube currency="USD" rate="1.4303"/><Cube

    currency="JPY" rate="135.86"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.695"/><Cube currency="DKK" rate="7.4449"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8492"/><Cube

    currency="HUF" rate="265.7"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7023"/><Cube currency="PLN" rate="4.1088"/><Cube

    currency="RON" rate="4.203"/><Cube currency="SEK" rate="10.2983"/><Cube

    currency="CHF" rate="1.5246"/><Cube currency="NOK" rate="8.68"/><Cube

    currency="HRK" rate="7.356"/><Cube currency="RUB" rate="44.4465"/><Cube

    currency="TRY" rate="2.0956"/><Cube currency="AUD" rate="1.702"/><Cube

    currency="BRL" rate="2.6482"/><Cube currency="CAD" rate="1.5274"/><Cube

    currency="CNY" rate="9.7701"/><Cube currency="HKD" rate="11.0849"/><Cube

    currency="IDR" rate="14163.96"/><Cube currency="INR" rate="68.068"/><Cube

    currency="KRW" rate="1745.63"/><Cube currency="MXN" rate="18.7627"/><Cube

    currency="MYR" rate="5.0168"/><Cube currency="NZD" rate="2.1445"/><Cube

    currency="PHP" rate="68.742"/><Cube currency="SGD" rate="2.0513"/><Cube

    currency="THB" rate="48.652"/><Cube currency="ZAR" rate="11.0823"/></Cube>

    <Cube time="2009-07-31"><Cube currency="USD" rate="1.4138"/><Cube

    currency="JPY" rate="135.33"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.573"/><Cube currency="DKK" rate="7.4461"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8556"/><Cube

    currency="HUF" rate="266.53"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7023"/><Cube currency="PLN" rate="4.159"/><Cube

    currency="RON" rate="4.2185"/><Cube currency="SEK" rate="10.3358"/><Cube

    currency="CHF" rate="1.5317"/><Cube currency="NOK" rate="8.715"/><Cube

    currency="HRK" rate="7.3523"/><Cube currency="RUB" rate="44.54"/><Cube

    currency="TRY" rate="2.087"/><Cube currency="AUD" rate="1.706"/><Cube

    currency="BRL" rate="2.6482"/><Cube currency="CAD" rate="1.5234"/><Cube

    currency="CNY" rate="9.6592"/><Cube currency="HKD" rate="10.957"/><Cube

    currency="IDR" rate="14068.37"/><Cube currency="INR" rate="67.95"/><Cube

    currency="KRW" rate="1728.71"/><Cube currency="MXN" rate="18.6678"/><Cube

    currency="MYR" rate="4.9801"/><Cube currency="NZD" rate="2.1578"/><Cube

    currency="PHP" rate="67.941"/><Cube currency="SGD" rate="2.0377"/><Cube

    currency="THB" rate="48.112"/><Cube currency="ZAR" rate="11.0368"/></Cube>

    <Cube time="2009-07-30"><Cube currency="USD" rate="1.4053"/><Cube

    currency="JPY" rate="133.89"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.581"/><Cube currency="DKK" rate="7.4453"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8524"/><Cube

    currency="HUF" rate="268.31"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7014"/><Cube currency="PLN" rate="4.1775"/><Cube

    currency="RON" rate="4.207"/><Cube currency="SEK" rate="10.4515"/><Cube

    currency="CHF" rate="1.5314"/><Cube currency="NOK" rate="8.749"/><Cube

    currency="HRK" rate="7.3615"/><Cube currency="RUB" rate="44.506"/><Cube

    currency="TRY" rate="2.0861"/><Cube currency="AUD" rate="1.7042"/><Cube

    currency="BRL" rate="2.6495"/><Cube currency="CAD" rate="1.524"/><Cube

    currency="CNY" rate="9.6014"/><Cube currency="HKD" rate="10.8911"/><Cube

    currency="IDR" rate="13989.56"/><Cube currency="INR" rate="67.89"/><Cube

    currency="KRW" rate="1735.5"/><Cube currency="MXN" rate="18.6483"/><Cube

    currency="MYR" rate="4.9628"/><Cube currency="NZD" rate="2.1555"/><Cube

    currency="PHP" rate="67.602"/><Cube currency="SGD" rate="2.0296"/><Cube

    currency="THB" rate="47.857"/><Cube currency="ZAR" rate="11.0079"/></Cube>

    <Cube time="2009-07-29"><Cube currency="USD" rate="1.4104"/><Cube

    currency="JPY" rate="133.86"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.54"/><Cube currency="DKK" rate="7.4451"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8611"/><Cube

    currency="HUF" rate="269.75"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.702"/><Cube currency="PLN" rate="4.1928"/><Cube

    currency="RON" rate="4.2183"/><Cube currency="SEK" rate="10.5849"/><Cube

    currency="CHF" rate="1.5268"/><Cube currency="NOK" rate="8.789"/><Cube

    currency="HRK" rate="7.342"/><Cube currency="RUB" rate="44.217"/><Cube

    currency="TRY" rate="2.0975"/><Cube currency="AUD" rate="1.722"/><Cube

    currency="BRL" rate="2.6679"/><Cube currency="CAD" rate="1.5335"/><Cube

    currency="CNY" rate="9.635"/><Cube currency="HKD" rate="10.9307"/><Cube

    currency="IDR" rate="14043.96"/><Cube currency="INR" rate="68.3"/><Cube

    currency="KRW" rate="1752.15"/><Cube currency="MXN" rate="18.716"/><Cube

    currency="MYR" rate="4.9836"/><Cube currency="NZD" rate="2.1457"/><Cube

    currency="PHP" rate="67.859"/><Cube currency="SGD" rate="2.0353"/><Cube

    currency="THB" rate="47.989"/><Cube currency="ZAR" rate="11.1778"/></Cube>

    <Cube time="2009-07-28"><Cube currency="USD" rate="1.4229"/><Cube

    currency="JPY" rate="134.53"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.501"/><Cube currency="DKK" rate="7.4453"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8622"/><Cube

    currency="HUF" rate="267.55"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7012"/><Cube currency="PLN" rate="4.1765"/><Cube

    currency="RON" rate="4.205"/><Cube currency="SEK" rate="10.585"/><Cube

    currency="CHF" rate="1.5224"/><Cube currency="NOK" rate="8.766"/><Cube

    currency="HRK" rate="7.333"/><Cube currency="RUB" rate="43.8914"/><Cube

    currency="TRY" rate="2.0992"/><Cube currency="AUD" rate="1.7138"/><Cube

    currency="BRL" rate="2.6697"/><Cube currency="CAD" rate="1.5378"/><Cube

    currency="CNY" rate="9.7197"/><Cube currency="HKD" rate="11.0287"/><Cube

    currency="IDR" rate="14121.19"/><Cube currency="INR" rate="68.605"/><Cube

    currency="KRW" rate="1762.97"/><Cube currency="MXN" rate="18.8641"/><Cube

    currency="MYR" rate="4.9937"/><Cube currency="NZD" rate="2.1531"/><Cube

    currency="PHP" rate="68.334"/><Cube currency="SGD" rate="2.0497"/><Cube

    currency="THB" rate="48.3"/><Cube currency="ZAR" rate="11.1131"/></Cube>

    <Cube time="2009-07-27"><Cube currency="USD" rate="1.4269"/><Cube

    currency="JPY" rate="135.61"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.517"/><Cube currency="DKK" rate="7.4449"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8653"/><Cube

    currency="HUF" rate="268"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7024"/><Cube currency="PLN" rate="4.1761"/><Cube

    currency="RON" rate="4.2075"/><Cube currency="SEK" rate="10.5265"/><Cube

    currency="CHF" rate="1.5237"/><Cube currency="NOK" rate="8.801"/><Cube

    currency="HRK" rate="7.327"/><Cube currency="RUB" rate="43.8435"/><Cube

    currency="TRY" rate="2.1122"/><Cube currency="AUD" rate="1.7331"/><Cube

    currency="BRL" rate="2.695"/><Cube currency="CAD" rate="1.5433"/><Cube

    currency="CNY" rate="9.7472"/><Cube currency="HKD" rate="11.0586"/><Cube

    currency="IDR" rate="14222.2"/><Cube currency="INR" rate="68.727"/><Cube

    currency="KRW" rate="1772.48"/><Cube currency="MXN" rate="18.7709"/><Cube

    currency="MYR" rate="5.0205"/><Cube currency="NZD" rate="2.1697"/><Cube

    currency="PHP" rate="68.535"/><Cube currency="SGD" rate="2.0545"/><Cube

    currency="THB" rate="48.465"/><Cube currency="ZAR" rate="11.0541"/></Cube>

    <Cube time="2009-07-24"><Cube currency="USD" rate="1.4227"/><Cube

    currency="JPY" rate="134.92"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.472"/><Cube currency="DKK" rate="7.4447"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.867"/><Cube

    currency="HUF" rate="266.59"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.703"/><Cube currency="PLN" rate="4.188"/><Cube

    currency="RON" rate="4.215"/><Cube currency="SEK" rate="10.5995"/><Cube

    currency="CHF" rate="1.5217"/><Cube currency="NOK" rate="8.86"/><Cube

    currency="HRK" rate="7.332"/><Cube currency="RUB" rate="44.099"/><Cube

    currency="TRY" rate="2.11"/><Cube currency="AUD" rate="1.7413"/><Cube

    currency="BRL" rate="2.6904"/><Cube currency="CAD" rate="1.5407"/><Cube

    currency="CNY" rate="9.7185"/><Cube currency="HKD" rate="11.0259"/><Cube

    currency="IDR" rate="14226.34"/><Cube currency="INR" rate="68.617"/><Cube

    currency="KRW" rate="1775.37"/><Cube currency="MXN" rate="18.7555"/><Cube

    currency="MYR" rate="5.0214"/><Cube currency="NZD" rate="2.1663"/><Cube

    currency="PHP" rate="68.387"/><Cube currency="SGD" rate="2.0487"/><Cube

    currency="THB" rate="48.322"/><Cube currency="ZAR" rate="11.0494"/></Cube>

    <Cube time="2009-07-23"><Cube currency="USD" rate="1.4229"/><Cube

    currency="JPY" rate="134.23"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.625"/><Cube currency="DKK" rate="7.4452"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8617"/><Cube

    currency="HUF" rate="271.26"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.703"/><Cube currency="PLN" rate="4.25"/><Cube

    currency="RON" rate="4.235"/><Cube currency="SEK" rate="10.7567"/><Cube

    currency="CHF" rate="1.5203"/><Cube currency="NOK" rate="8.925"/><Cube

    currency="HRK" rate="7.319"/><Cube currency="RUB" rate="44.361"/><Cube

    currency="TRY" rate="2.118"/><Cube currency="AUD" rate="1.7376"/><Cube

    currency="BRL" rate="2.6957"/><Cube currency="CAD" rate="1.5606"/><Cube

    currency="CNY" rate="9.7198"/><Cube currency="HKD" rate="11.0275"/><Cube

    currency="IDR" rate="14268.07"/><Cube currency="INR" rate="68.94"/><Cube

    currency="KRW" rate="1779.06"/><Cube currency="MXN" rate="18.7681"/><Cube

    currency="MYR" rate="5.0371"/><Cube currency="NZD" rate="2.1579"/><Cube

    currency="PHP" rate="68.426"/><Cube currency="SGD" rate="2.0504"/><Cube

    currency="THB" rate="48.357"/><Cube currency="ZAR" rate="10.9471"/></Cube>

    <Cube time="2009-07-22"><Cube currency="USD" rate="1.4191"/><Cube

    currency="JPY" rate="132.49"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.825"/><Cube currency="DKK" rate="7.4458"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8648"/><Cube

    currency="HUF" rate="271.55"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.702"/><Cube currency="PLN" rate="4.2548"/><Cube

    currency="RON" rate="4.2348"/><Cube currency="SEK" rate="10.8073"/><Cube

    currency="CHF" rate="1.5164"/><Cube currency="NOK" rate="8.92"/><Cube

    currency="HRK" rate="7.3362"/><Cube currency="RUB" rate="44.2661"/><Cube

    currency="TRY" rate="2.1247"/><Cube currency="AUD" rate="1.7455"/><Cube

    currency="BRL" rate="2.6989"/><Cube currency="CAD" rate="1.5704"/><Cube

    currency="CNY" rate="9.6933"/><Cube currency="HKD" rate="10.998"/><Cube

    currency="IDR" rate="14316.74"/><Cube currency="INR" rate="68.855"/><Cube

    currency="KRW" rate="1777.34"/><Cube currency="MXN" rate="18.8286"/><Cube

    currency="MYR" rate="5.0421"/><Cube currency="NZD" rate="2.1657"/><Cube

    currency="PHP" rate="68.065"/><Cube currency="SGD" rate="2.048"/><Cube

    currency="THB" rate="48.271"/><Cube currency="ZAR" rate="11.0069"/></Cube>

    <Cube time="2009-07-21"><Cube currency="USD" rate="1.4223"/><Cube

    currency="JPY" rate="134.1"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.815"/><Cube currency="DKK" rate="7.4464"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8653"/><Cube

    currency="HUF" rate="271.3"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7005"/><Cube currency="PLN" rate="4.2525"/><Cube

    currency="RON" rate="4.2368"/><Cube currency="SEK" rate="10.8925"/><Cube

    currency="CHF" rate="1.5186"/><Cube currency="NOK" rate="8.9515"/><Cube

    currency="HRK" rate="7.334"/><Cube currency="RUB" rate="44.11"/><Cube

    currency="TRY" rate="2.136"/><Cube currency="AUD" rate="1.7438"/><Cube

    currency="BRL" rate="2.701"/><Cube currency="CAD" rate="1.5689"/><Cube

    currency="CNY" rate="9.7153"/><Cube currency="HKD" rate="11.0229"/><Cube

    currency="IDR" rate="14301.78"/><Cube currency="INR" rate="68.896"/><Cube

    currency="KRW" rate="1774.19"/><Cube currency="MXN" rate="18.8597"/><Cube

    currency="MYR" rate="5.0378"/><Cube currency="NZD" rate="2.1647"/><Cube

    currency="PHP" rate="68.161"/><Cube currency="SGD" rate="2.0491"/><Cube

    currency="THB" rate="48.351"/><Cube currency="ZAR" rate="11.1587"/></Cube>

    <Cube time="2009-07-20"><Cube currency="USD" rate="1.4217"/><Cube

    currency="JPY" rate="134.44"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.838"/><Cube currency="DKK" rate="7.4462"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8601"/><Cube

    currency="HUF" rate="272.9"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7004"/><Cube currency="PLN" rate="4.298"/><Cube

    currency="RON" rate="4.239"/><Cube currency="SEK" rate="11.0023"/><Cube

    currency="CHF" rate="1.5198"/><Cube currency="NOK" rate="9.0085"/><Cube

    currency="HRK" rate="7.3352"/><Cube currency="RUB" rate="43.98"/><Cube

    currency="TRY" rate="2.1476"/><Cube currency="AUD" rate="1.751"/><Cube

    currency="BRL" rate="2.7122"/><Cube currency="CAD" rate="1.5702"/><Cube

    currency="CNY" rate="9.7118"/><Cube currency="HKD" rate="11.0184"/><Cube

    currency="IDR" rate="14202.88"/><Cube currency="INR" rate="68.533"/><Cube

    currency="KRW" rate="1772.41"/><Cube currency="MXN" rate="18.7878"/><Cube

    currency="MYR" rate="5.035"/><Cube currency="NZD" rate="2.1714"/><Cube

    currency="PHP" rate="68.141"/><Cube currency="SGD" rate="2.0489"/><Cube

    currency="THB" rate="48.359"/><Cube currency="ZAR" rate="11.2989"/></Cube>

    <Cube time="2009-07-17"><Cube currency="USD" rate="1.409"/><Cube

    currency="JPY" rate="132.06"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.918"/><Cube currency="DKK" rate="7.4453"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8653"/><Cube

    currency="HUF" rate="274.2"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.3355"/><Cube

    currency="RON" rate="4.2475"/><Cube currency="SEK" rate="11.0476"/><Cube

    currency="CHF" rate="1.5193"/><Cube currency="NOK" rate="8.996"/><Cube

    currency="HRK" rate="7.336"/><Cube currency="RUB" rate="44.801"/><Cube

    currency="TRY" rate="2.1525"/><Cube currency="AUD" rate="1.7621"/><Cube

    currency="BRL" rate="2.7293"/><Cube currency="CAD" rate="1.5734"/><Cube

    currency="CNY" rate="9.6259"/><Cube currency="HKD" rate="10.9198"/><Cube

    currency="IDR" rate="14340.05"/><Cube currency="INR" rate="68.661"/><Cube

    currency="KRW" rate="1780.6"/><Cube currency="MXN" rate="19.1765"/><Cube

    currency="MYR" rate="5.0238"/><Cube currency="NZD" rate="2.1884"/><Cube

    currency="PHP" rate="67.567"/><Cube currency="SGD" rate="2.0438"/><Cube

    currency="THB" rate="47.991"/><Cube currency="ZAR" rate="11.414"/></Cube>

    <Cube time="2009-07-16"><Cube currency="USD" rate="1.413"/><Cube

    currency="JPY" rate="132.63"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.861"/><Cube currency="DKK" rate="7.4456"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8591"/><Cube

    currency="HUF" rate="272.82"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7005"/><Cube currency="PLN" rate="4.29"/><Cube

    currency="RON" rate="4.2313"/><Cube currency="SEK" rate="11.0135"/><Cube

    currency="CHF" rate="1.5154"/><Cube currency="NOK" rate="9.0015"/><Cube

    currency="HRK" rate="7.327"/><Cube currency="RUB" rate="44.9351"/><Cube

    currency="TRY" rate="2.157"/><Cube currency="AUD" rate="1.7582"/><Cube

    currency="BRL" rate="2.7279"/><Cube currency="CAD" rate="1.5787"/><Cube

    currency="CNY" rate="9.6526"/><Cube currency="HKD" rate="10.9512"/><Cube

    currency="IDR" rate="14305.53"/><Cube currency="INR" rate="68.771"/><Cube

    currency="KRW" rate="1795.45"/><Cube currency="MXN" rate="19.1829"/><Cube

    currency="MYR" rate="5.0465"/><Cube currency="NZD" rate="2.1852"/><Cube

    currency="PHP" rate="67.739"/><Cube currency="SGD" rate="2.0501"/><Cube

    currency="THB" rate="48.13"/><Cube currency="ZAR" rate="11.4575"/></Cube>

    <Cube time="2009-07-15"><Cube currency="USD" rate="1.4089"/><Cube

    currency="JPY" rate="131.57"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.9"/><Cube currency="DKK" rate="7.4453"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8576"/><Cube

    currency="HUF" rate="273.25"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7004"/><Cube currency="PLN" rate="4.29"/><Cube

    currency="RON" rate="4.2165"/><Cube currency="SEK" rate="10.9746"/><Cube

    currency="CHF" rate="1.5179"/><Cube currency="NOK" rate="9.019"/><Cube

    currency="HRK" rate="7.324"/><Cube currency="RUB" rate="44.9035"/><Cube

    currency="TRY" rate="2.1625"/><Cube currency="AUD" rate="1.7551"/><Cube

    currency="BRL" rate="2.7472"/><Cube currency="CAD" rate="1.5813"/><Cube

    currency="CNY" rate="9.625"/><Cube currency="HKD" rate="10.9194"/><Cube

    currency="IDR" rate="14275.68"/><Cube currency="INR" rate="68.515"/><Cube

    currency="KRW" rate="1797.93"/><Cube currency="MXN" rate="19.2836"/><Cube

    currency="MYR" rate="5.0206"/><Cube currency="NZD" rate="2.178"/><Cube

    currency="PHP" rate="67.5"/><Cube currency="SGD" rate="2.046"/><Cube

    currency="THB" rate="48.01"/><Cube currency="ZAR" rate="11.4842"/></Cube>

    <Cube time="2009-07-14"><Cube currency="USD" rate="1.3991"/><Cube

    currency="JPY" rate="130.34"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.014"/><Cube currency="DKK" rate="7.4458"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85755"/><Cube

    currency="HUF" rate="275.79"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7012"/><Cube currency="PLN" rate="4.3557"/><Cube

    currency="RON" rate="4.2165"/><Cube currency="SEK" rate="10.9725"/><Cube

    currency="CHF" rate="1.5159"/><Cube currency="NOK" rate="9.0355"/><Cube

    currency="HRK" rate="7.332"/><Cube currency="RUB" rate="45.189"/><Cube

    currency="TRY" rate="2.154"/><Cube currency="AUD" rate="1.7689"/><Cube

    currency="BRL" rate="2.7537"/><Cube currency="CAD" rate="1.6018"/><Cube

    currency="CNY" rate="9.5599"/><Cube currency="HKD" rate="10.8436"/><Cube

    currency="IDR" rate="14284.31"/><Cube currency="INR" rate="68.507"/><Cube

    currency="KRW" rate="1815.93"/><Cube currency="MXN" rate="19.1327"/><Cube

    currency="MYR" rate="5.0179"/><Cube currency="NZD" rate="2.1988"/><Cube

    currency="PHP" rate="67.362"/><Cube currency="SGD" rate="2.0404"/><Cube

    currency="THB" rate="47.758"/><Cube currency="ZAR" rate="11.4694"/></Cube>

    <Cube time="2009-07-13"><Cube currency="USD" rate="1.3975"/><Cube

    currency="JPY" rate="129.03"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.028"/><Cube currency="DKK" rate="7.4451"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8678"/><Cube

    currency="HUF" rate="277.96"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.402"/><Cube

    currency="RON" rate="4.2238"/><Cube currency="SEK" rate="11.0518"/><Cube

    currency="CHF" rate="1.5133"/><Cube currency="NOK" rate="9.07"/><Cube

    currency="HRK" rate="7.331"/><Cube currency="RUB" rate="45.89"/><Cube

    currency="TRY" rate="2.1701"/><Cube currency="AUD" rate="1.801"/><Cube

    currency="BRL" rate="2.785"/><Cube currency="CAD" rate="1.6239"/><Cube

    currency="CNY" rate="9.5487"/><Cube currency="HKD" rate="10.8308"/><Cube

    currency="IDR" rate="14310.09"/><Cube currency="INR" rate="68.603"/><Cube

    currency="KRW" rate="1831.85"/><Cube currency="MXN" rate="19.1576"/><Cube

    currency="MYR" rate="5.0338"/><Cube currency="NZD" rate="2.2407"/><Cube

    currency="PHP" rate="67.508"/><Cube currency="SGD" rate="2.0483"/><Cube

    currency="THB" rate="47.732"/><Cube currency="ZAR" rate="11.5835"/></Cube>

    <Cube time="2009-07-10"><Cube currency="USD" rate="1.3901"/><Cube

    currency="JPY" rate="128.21"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.03"/><Cube currency="DKK" rate="7.4466"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.858"/><Cube

    currency="HUF" rate="277.5"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6993"/><Cube currency="PLN" rate="4.374"/><Cube

    currency="RON" rate="4.216"/><Cube currency="SEK" rate="11.0022"/><Cube

    currency="CHF" rate="1.514"/><Cube currency="NOK" rate="9.084"/><Cube

    currency="HRK" rate="7.3315"/><Cube currency="RUB" rate="45.4005"/><Cube

    currency="TRY" rate="2.1636"/><Cube currency="AUD" rate="1.794"/><Cube

    currency="BRL" rate="2.8084"/><Cube currency="CAD" rate="1.6212"/><Cube

    currency="CNY" rate="9.4983"/><Cube currency="HKD" rate="10.7736"/><Cube

    currency="IDR" rate="14174.11"/><Cube currency="INR" rate="67.823"/><Cube

    currency="KRW" rate="1786.89"/><Cube currency="MXN" rate="19.0303"/><Cube

    currency="MYR" rate="4.9731"/><Cube currency="NZD" rate="2.225"/><Cube

    currency="PHP" rate="67.026"/><Cube currency="SGD" rate="2.0331"/><Cube

    currency="THB" rate="47.382"/><Cube currency="ZAR" rate="11.4023"/></Cube>

    <Cube time="2009-07-09"><Cube currency="USD" rate="1.399"/><Cube

    currency="JPY" rate="130.05"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.933"/><Cube currency="DKK" rate="7.4469"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8606"/><Cube

    currency="HUF" rate="275"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6997"/><Cube currency="PLN" rate="4.3548"/><Cube

    currency="RON" rate="4.2142"/><Cube currency="SEK" rate="10.9785"/><Cube

    currency="CHF" rate="1.5119"/><Cube currency="NOK" rate="9.074"/><Cube

    currency="HRK" rate="7.345"/><Cube currency="RUB" rate="44.52"/><Cube

    currency="TRY" rate="2.1625"/><Cube currency="AUD" rate="1.7831"/><Cube

    currency="BRL" rate="2.8025"/><Cube currency="CAD" rate="1.6182"/><Cube

    currency="CNY" rate="9.5575"/><Cube currency="HKD" rate="10.8426"/><Cube

    currency="IDR" rate="14193.23"/><Cube currency="INR" rate="68.145"/><Cube

    currency="KRW" rate="1787.29"/><Cube currency="MXN" rate="18.8424"/><Cube

    currency="MYR" rate="4.986"/><Cube currency="NZD" rate="2.2194"/><Cube

    currency="PHP" rate="67.306"/><Cube currency="SGD" rate="2.0408"/><Cube

    currency="THB" rate="47.669"/><Cube currency="ZAR" rate="11.333"/></Cube>

    <Cube time="2009-07-08"><Cube currency="USD" rate="1.3901"/><Cube

    currency="JPY" rate="131.02"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.047"/><Cube currency="DKK" rate="7.4469"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.86495"/><Cube

    currency="HUF" rate="278.1"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.4338"/><Cube

    currency="RON" rate="4.2178"/><Cube currency="SEK" rate="11.06"/><Cube

    currency="CHF" rate="1.5162"/><Cube currency="NOK" rate="9.077"/><Cube

    currency="HRK" rate="7.343"/><Cube currency="RUB" rate="44.125"/><Cube

    currency="TRY" rate="2.1623"/><Cube currency="AUD" rate="1.7728"/><Cube

    currency="BRL" rate="2.7686"/><Cube currency="CAD" rate="1.6206"/><Cube

    currency="CNY" rate="9.4984"/><Cube currency="HKD" rate="10.7738"/><Cube

    currency="IDR" rate="14248.39"/><Cube currency="INR" rate="67.962"/><Cube

    currency="KRW" rate="1776.14"/><Cube currency="MXN" rate="18.701"/><Cube

    currency="MYR" rate="4.9522"/><Cube currency="NZD" rate="2.2168"/><Cube

    currency="PHP" rate="67.049"/><Cube currency="SGD" rate="2.0323"/><Cube

    currency="THB" rate="47.368"/><Cube currency="ZAR" rate="11.345"/></Cube>

    <Cube time="2009-07-07"><Cube currency="USD" rate="1.4019"/><Cube

    currency="JPY" rate="133.61"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.882"/><Cube currency="DKK" rate="7.4465"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8638"/><Cube

    currency="HUF" rate="273.2"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6971"/><Cube currency="PLN" rate="4.374"/><Cube

    currency="RON" rate="4.2117"/><Cube currency="SEK" rate="10.965"/><Cube

    currency="CHF" rate="1.5181"/><Cube currency="NOK" rate="9.0565"/><Cube

    currency="HRK" rate="7.3425"/><Cube currency="RUB" rate="44.0625"/><Cube

    currency="TRY" rate="2.1593"/><Cube currency="AUD" rate="1.7484"/><Cube

    currency="BRL" rate="2.7321"/><Cube currency="CAD" rate="1.6223"/><Cube

    currency="CNY" rate="9.5788"/><Cube currency="HKD" rate="10.8648"/><Cube

    currency="IDR" rate="14374.43"/><Cube currency="INR" rate="67.614"/><Cube

    currency="KRW" rate="1784.41"/><Cube currency="MXN" rate="18.51"/><Cube

    currency="MYR" rate="4.9746"/><Cube currency="NZD" rate="2.1996"/><Cube

    currency="PHP" rate="67.591"/><Cube currency="SGD" rate="2.042"/><Cube

    currency="THB" rate="47.794"/><Cube currency="ZAR" rate="11.1837"/></Cube>

    <Cube time="2009-07-06"><Cube currency="USD" rate="1.3897"/><Cube

    currency="JPY" rate="132.44"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.954"/><Cube currency="DKK" rate="7.4461"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8612"/><Cube

    currency="HUF" rate="273.7"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6969"/><Cube currency="PLN" rate="4.387"/><Cube

    currency="RON" rate="4.2083"/><Cube currency="SEK" rate="10.9205"/><Cube

    currency="CHF" rate="1.5198"/><Cube currency="NOK" rate="9.054"/><Cube

    currency="HRK" rate="7.3296"/><Cube currency="RUB" rate="43.811"/><Cube

    currency="TRY" rate="2.154"/><Cube currency="AUD" rate="1.7605"/><Cube

    currency="BRL" rate="2.7401"/><Cube currency="CAD" rate="1.6193"/><Cube

    currency="CNY" rate="9.4979"/><Cube currency="HKD" rate="10.7704"/><Cube

    currency="IDR" rate="14217.14"/><Cube currency="INR" rate="67.505"/><Cube

    currency="KRW" rate="1762.78"/><Cube currency="MXN" rate="18.549"/><Cube

    currency="MYR" rate="4.9265"/><Cube currency="NZD" rate="2.2175"/><Cube

    currency="PHP" rate="67.069"/><Cube currency="SGD" rate="2.0265"/><Cube

    currency="THB" rate="47.424"/><Cube currency="ZAR" rate="11.135"/></Cube>

    <Cube time="2009-07-03"><Cube currency="USD" rate="1.4009"/><Cube

    currency="JPY" rate="134.32"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.865"/><Cube currency="DKK" rate="7.4459"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85625"/><Cube

    currency="HUF" rate="272.55"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6975"/><Cube currency="PLN" rate="4.3525"/><Cube

    currency="RON" rate="4.2035"/><Cube currency="SEK" rate="10.9135"/><Cube

    currency="CHF" rate="1.5228"/><Cube currency="NOK" rate="8.966"/><Cube

    currency="HRK" rate="7.3208"/><Cube currency="RUB" rate="43.7877"/><Cube

    currency="TRY" rate="2.148"/><Cube currency="AUD" rate="1.7552"/><Cube

    currency="BRL" rate="2.7271"/><Cube currency="CAD" rate="1.6203"/><Cube

    currency="CNY" rate="9.5714"/><Cube currency="HKD" rate="10.857"/><Cube

    currency="IDR" rate="14274.83"/><Cube currency="INR" rate="67.075"/><Cube

    currency="KRW" rate="1773.07"/><Cube currency="MXN" rate="18.5339"/><Cube

    currency="MYR" rate="4.9403"/><Cube currency="NZD" rate="2.2119"/><Cube

    currency="PHP" rate="67.282"/><Cube currency="SGD" rate="2.0352"/><Cube

    currency="THB" rate="47.757"/><Cube currency="ZAR" rate="11.082"/></Cube>

    <Cube time="2009-07-02"><Cube currency="USD" rate="1.4049"/><Cube

    currency="JPY" rate="135.95"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.755"/><Cube currency="DKK" rate="7.446"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8573"/><Cube

    currency="HUF" rate="268.45"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7005"/><Cube currency="PLN" rate="4.3543"/><Cube

    currency="RON" rate="4.2062"/><Cube currency="SEK" rate="10.84"/><Cube

    currency="CHF" rate="1.5235"/><Cube currency="NOK" rate="8.9375"/><Cube

    currency="HRK" rate="7.2992"/><Cube currency="RUB" rate="43.8009"/><Cube

    currency="TRY" rate="2.1489"/><Cube currency="AUD" rate="1.7525"/><Cube

    currency="BRL" rate="2.7222"/><Cube currency="CAD" rate="1.6201"/><Cube

    currency="CNY" rate="9.5974"/><Cube currency="HKD" rate="10.8879"/><Cube

    currency="IDR" rate="14374.42"/><Cube currency="INR" rate="67.358"/><Cube

    currency="KRW" rate="1783.8"/><Cube currency="MXN" rate="18.4393"/><Cube

    currency="MYR" rate="4.9452"/><Cube currency="NZD" rate="2.2168"/><Cube

    currency="PHP" rate="67.569"/><Cube currency="SGD" rate="2.0377"/><Cube

    currency="THB" rate="47.9"/><Cube currency="ZAR" rate="10.9708"/></Cube>

    <Cube time="2009-07-01"><Cube currency="USD" rate="1.4096"/><Cube

    currency="JPY" rate="136.53"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.77"/><Cube currency="DKK" rate="7.4455"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8562"/><Cube

    currency="HUF" rate="271.11"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7024"/><Cube currency="PLN" rate="4.3904"/><Cube

    currency="RON" rate="4.1941"/><Cube currency="SEK" rate="10.72"/><Cube

    currency="CHF" rate="1.5241"/><Cube currency="NOK" rate="8.98"/><Cube

    currency="HRK" rate="7.2715"/><Cube currency="RUB" rate="43.887"/><Cube

    currency="TRY" rate="2.1559"/><Cube currency="AUD" rate="1.7485"/><Cube

    currency="BRL" rate="2.7367"/><Cube currency="CAD" rate="1.6224"/><Cube

    currency="CNY" rate="9.6319"/><Cube currency="HKD" rate="10.9247"/><Cube

    currency="IDR" rate="14421.33"/><Cube currency="INR" rate="67.513"/><Cube

    currency="KRW" rate="1797.53"/><Cube currency="MXN" rate="18.5228"/><Cube

    currency="MYR" rate="4.9604"/><Cube currency="NZD" rate="2.2017"/><Cube

    currency="PHP" rate="67.623"/><Cube currency="SGD" rate="2.0393"/><Cube

    currency="THB" rate="47.99"/><Cube currency="ZAR" rate="10.9048"/></Cube>

    <Cube time="2009-06-30"><Cube currency="USD" rate="1.4134"/><Cube

    currency="JPY" rate="135.51"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.882"/><Cube currency="DKK" rate="7.447"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8521"/><Cube

    currency="HUF" rate="271.55"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7036"/><Cube currency="PLN" rate="4.452"/><Cube

    currency="RON" rate="4.2072"/><Cube currency="SEK" rate="10.8125"/><Cube

    currency="CHF" rate="1.5265"/><Cube currency="NOK" rate="9.018"/><Cube

    currency="HRK" rate="7.273"/><Cube currency="RUB" rate="43.881"/><Cube

    currency="TRY" rate="2.1614"/><Cube currency="AUD" rate="1.7359"/><Cube

    currency="BRL" rate="2.7469"/><Cube currency="CAD" rate="1.6275"/><Cube

    currency="CNY" rate="9.6545"/><Cube currency="HKD" rate="10.954"/><Cube

    currency="IDR" rate="14427.58"/><Cube currency="INR" rate="67.518"/><Cube

    currency="KRW" rate="1802.43"/><Cube currency="MXN" rate="18.5537"/><Cube

    currency="MYR" rate="4.9681"/><Cube currency="NZD" rate="2.1656"/><Cube

    currency="PHP" rate="67.865"/><Cube currency="SGD" rate="2.0441"/><Cube

    currency="THB" rate="48.14"/><Cube currency="ZAR" rate="10.8853"/></Cube>

    <Cube time="2009-06-29"><Cube currency="USD" rate="1.4058"/><Cube

    currency="JPY" rate="134.03"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.02"/><Cube currency="DKK" rate="7.4463"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84865"/><Cube

    currency="HUF" rate="276.21"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7007"/><Cube currency="PLN" rate="4.496"/><Cube

    currency="RON" rate="4.2135"/><Cube currency="SEK" rate="10.8658"/><Cube

    currency="CHF" rate="1.526"/><Cube currency="NOK" rate="9.034"/><Cube

    currency="HRK" rate="7.2801"/><Cube currency="RUB" rate="43.8375"/><Cube

    currency="TRY" rate="2.1619"/><Cube currency="AUD" rate="1.7451"/><Cube

    currency="BRL" rate="2.7209"/><Cube currency="CAD" rate="1.6236"/><Cube

    currency="CNY" rate="9.607"/><Cube currency="HKD" rate="10.8949"/><Cube

    currency="IDR" rate="14435.59"/><Cube currency="INR" rate="67.549"/><Cube

    currency="KRW" rate="1807.3"/><Cube currency="MXN" rate="18.5321"/><Cube

    currency="MYR" rate="4.9758"/><Cube currency="NZD" rate="2.1673"/><Cube

    currency="PHP" rate="67.783"/><Cube currency="SGD" rate="2.0444"/><Cube

    currency="THB" rate="47.846"/><Cube currency="ZAR" rate="10.9867"/></Cube>

    <Cube time="2009-06-26"><Cube currency="USD" rate="1.4096"/><Cube

    currency="JPY" rate="134.5"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="25.998"/><Cube currency="DKK" rate="7.4464"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8543"/><Cube

    currency="HUF" rate="275.3"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.699"/><Cube currency="PLN" rate="4.4945"/><Cube

    currency="RON" rate="4.2174"/><Cube currency="SEK" rate="10.9595"/><Cube

    currency="CHF" rate="1.5275"/><Cube currency="NOK" rate="9.04"/><Cube

    currency="HRK" rate="7.286"/><Cube currency="RUB" rate="43.858"/><Cube

    currency="TRY" rate="2.1645"/><Cube currency="AUD" rate="1.7457"/><Cube

    currency="BRL" rate="2.721"/><Cube currency="CAD" rate="1.6168"/><Cube

    currency="CNY" rate="9.6329"/><Cube currency="HKD" rate="10.9245"/><Cube

    currency="IDR" rate="14407.13"/><Cube currency="INR" rate="67.802"/><Cube

    currency="KRW" rate="1805.28"/><Cube currency="MXN" rate="18.5461"/><Cube

    currency="MYR" rate="4.9794"/><Cube currency="NZD" rate="2.1795"/><Cube

    currency="PHP" rate="67.921"/><Cube currency="SGD" rate="2.0493"/><Cube

    currency="THB" rate="47.997"/><Cube currency="ZAR" rate="11.1439"/></Cube>

    <Cube time="2009-06-25"><Cube currency="USD" rate="1.394"/><Cube

    currency="JPY" rate="134.34"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.08"/><Cube currency="DKK" rate="7.4455"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8567"/><Cube

    currency="HUF" rate="277.1"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6963"/><Cube currency="PLN" rate="4.516"/><Cube

    currency="RON" rate="4.2232"/><Cube currency="SEK" rate="11.0718"/><Cube

    currency="CHF" rate="1.5311"/><Cube currency="NOK" rate="9.076"/><Cube

    currency="HRK" rate="7.3105"/><Cube currency="RUB" rate="43.54"/><Cube

    currency="TRY" rate="2.1691"/><Cube currency="AUD" rate="1.7488"/><Cube

    currency="BRL" rate="2.7368"/><Cube currency="CAD" rate="1.62"/><Cube

    currency="CNY" rate="9.5276"/><Cube currency="HKD" rate="10.8037"/><Cube

    currency="IDR" rate="14328.78"/><Cube currency="INR" rate="67.752"/><Cube

    currency="KRW" rate="1794.95"/><Cube currency="MXN" rate="18.4593"/><Cube

    currency="MYR" rate="4.9292"/><Cube currency="NZD" rate="2.187"/><Cube

    currency="PHP" rate="67.111"/><Cube currency="SGD" rate="2.0336"/><Cube

    currency="THB" rate="47.57"/><Cube currency="ZAR" rate="11.2586"/></Cube>

    <Cube time="2009-06-24"><Cube currency="USD" rate="1.4029"/><Cube

    currency="JPY" rate="133.77"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.16"/><Cube currency="DKK" rate="7.4447"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8493"/><Cube

    currency="HUF" rate="277.75"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.697"/><Cube currency="PLN" rate="4.532"/><Cube

    currency="RON" rate="4.2268"/><Cube currency="SEK" rate="11.026"/><Cube

    currency="CHF" rate="1.5183"/><Cube currency="NOK" rate="9.009"/><Cube

    currency="HRK" rate="7.3147"/><Cube currency="RUB" rate="43.8104"/><Cube

    currency="TRY" rate="2.1829"/><Cube currency="AUD" rate="1.7566"/><Cube

    currency="BRL" rate="2.7652"/><Cube currency="CAD" rate="1.6105"/><Cube

    currency="CNY" rate="9.5857"/><Cube currency="HKD" rate="10.8725"/><Cube

    currency="IDR" rate="14564.2"/><Cube currency="INR" rate="68.083"/><Cube

    currency="KRW" rate="1799.18"/><Cube currency="MXN" rate="18.6351"/><Cube

    currency="MYR" rate="4.9564"/><Cube currency="NZD" rate="2.1806"/><Cube

    currency="PHP" rate="67.514"/><Cube currency="SGD" rate="2.0401"/><Cube

    currency="THB" rate="47.888"/><Cube currency="ZAR" rate="11.2993"/></Cube>

    <Cube time="2009-06-23"><Cube currency="USD" rate="1.3978"/><Cube

    currency="JPY" rate="133.49"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.207"/><Cube currency="DKK" rate="7.4442"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85735"/><Cube

    currency="HUF" rate="281.2"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.697"/><Cube currency="PLN" rate="4.5462"/><Cube

    currency="RON" rate="4.235"/><Cube currency="SEK" rate="11.1025"/><Cube

    currency="CHF" rate="1.5031"/><Cube currency="NOK" rate="9.099"/><Cube

    currency="HRK" rate="7.2725"/><Cube currency="RUB" rate="43.93"/><Cube

    currency="TRY" rate="2.1944"/><Cube currency="AUD" rate="1.7744"/><Cube

    currency="BRL" rate="2.8152"/><Cube currency="CAD" rate="1.6101"/><Cube

    currency="CNY" rate="9.5537"/><Cube currency="HKD" rate="10.8331"/><Cube

    currency="IDR" rate="14691.82"/><Cube currency="INR" rate="67.867"/><Cube

    currency="KRW" rate="1799.72"/><Cube currency="MXN" rate="18.5385"/><Cube

    currency="MYR" rate="4.958"/><Cube currency="NZD" rate="2.2046"/><Cube

    currency="PHP" rate="67.5"/><Cube currency="SGD" rate="2.037"/><Cube

    currency="THB" rate="47.742"/><Cube currency="ZAR" rate="11.4724"/></Cube>

    <Cube time="2009-06-22"><Cube currency="USD" rate="1.3858"/><Cube

    currency="JPY" rate="133.02"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.019"/><Cube currency="DKK" rate="7.4444"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84255"/><Cube

    currency="HUF" rate="278.62"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.697"/><Cube currency="PLN" rate="4.523"/><Cube

    currency="RON" rate="4.2203"/><Cube currency="SEK" rate="11.0785"/><Cube

    currency="CHF" rate="1.5074"/><Cube currency="NOK" rate="8.986"/><Cube

    currency="HRK" rate="7.2664"/><Cube currency="RUB" rate="43.41"/><Cube

    currency="TRY" rate="2.1652"/><Cube currency="AUD" rate="1.742"/><Cube

    currency="BRL" rate="2.7612"/><Cube currency="CAD" rate="1.5871"/><Cube

    currency="CNY" rate="9.4728"/><Cube currency="HKD" rate="10.7404"/><Cube

    currency="IDR" rate="14494.01"/><Cube currency="INR" rate="67.114"/><Cube

    currency="KRW" rate="1771.4"/><Cube currency="MXN" rate="18.6446"/><Cube

    currency="MYR" rate="4.9064"/><Cube currency="NZD" rate="2.1844"/><Cube

    currency="PHP" rate="66.871"/><Cube currency="SGD" rate="2.0214"/><Cube

    currency="THB" rate="47.335"/><Cube currency="ZAR" rate="11.2912"/></Cube>

    <Cube time="2009-06-19"><Cube currency="USD" rate="1.3932"/><Cube

    currency="JPY" rate="134.84"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.357"/><Cube currency="DKK" rate="7.4434"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84715"/><Cube

    currency="HUF" rate="279.5"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6975"/><Cube currency="PLN" rate="4.5138"/><Cube

    currency="RON" rate="4.2143"/><Cube currency="SEK" rate="10.9725"/><Cube

    currency="CHF" rate="1.5102"/><Cube currency="NOK" rate="8.8995"/><Cube

    currency="HRK" rate="7.278"/><Cube currency="RUB" rate="43.4098"/><Cube

    currency="TRY" rate="2.1642"/><Cube currency="AUD" rate="1.7283"/><Cube

    currency="BRL" rate="2.7325"/><Cube currency="CAD" rate="1.5708"/><Cube

    currency="CNY" rate="9.5242"/><Cube currency="HKD" rate="10.7976"/><Cube

    currency="IDR" rate="14491"/><Cube currency="INR" rate="66.888"/><Cube

    currency="KRW" rate="1761.36"/><Cube currency="MXN" rate="18.5714"/><Cube

    currency="MYR" rate="4.9264"/><Cube currency="NZD" rate="2.1685"/><Cube

    currency="PHP" rate="67.36"/><Cube currency="SGD" rate="2.0274"/><Cube

    currency="THB" rate="47.585"/><Cube currency="ZAR" rate="11.291"/></Cube>

    <Cube time="2009-06-18"><Cube currency="USD" rate="1.392"/><Cube

    currency="JPY" rate="133.57"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.645"/><Cube currency="DKK" rate="7.444"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8583"/><Cube

    currency="HUF" rate="283.57"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.698"/><Cube currency="PLN" rate="4.5575"/><Cube

    currency="RON" rate="4.2319"/><Cube currency="SEK" rate="10.966"/><Cube

    currency="CHF" rate="1.5013"/><Cube currency="NOK" rate="8.8825"/><Cube

    currency="HRK" rate="7.292"/><Cube currency="RUB" rate="43.4455"/><Cube

    currency="TRY" rate="2.1822"/><Cube currency="AUD" rate="1.7528"/><Cube

    currency="BRL" rate="2.7519"/><Cube currency="CAD" rate="1.5758"/><Cube

    currency="CNY" rate="9.5139"/><Cube currency="HKD" rate="10.7885"/><Cube

    currency="IDR" rate="14310.78"/><Cube currency="INR" rate="66.969"/><Cube

    currency="KRW" rate="1761.44"/><Cube currency="MXN" rate="18.6946"/><Cube

    currency="MYR" rate="4.9284"/><Cube currency="NZD" rate="2.1923"/><Cube

    currency="PHP" rate="67.322"/><Cube currency="SGD" rate="2.0292"/><Cube

    currency="THB" rate="47.533"/><Cube currency="ZAR" rate="11.348"/></Cube>

    <Cube time="2009-06-17"><Cube currency="USD" rate="1.384"/><Cube

    currency="JPY" rate="133.28"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.695"/><Cube currency="DKK" rate="7.4447"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8522"/><Cube

    currency="HUF" rate="283.8"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6985"/><Cube currency="PLN" rate="4.5283"/><Cube

    currency="RON" rate="4.2323"/><Cube currency="SEK" rate="10.8932"/><Cube

    currency="CHF" rate="1.5096"/><Cube currency="NOK" rate="8.918"/><Cube

    currency="HRK" rate="7.278"/><Cube currency="RUB" rate="43.324"/><Cube

    currency="TRY" rate="2.1575"/><Cube currency="AUD" rate="1.7528"/><Cube

    currency="BRL" rate="2.7427"/><Cube currency="CAD" rate="1.5794"/><Cube

    currency="CNY" rate="9.463"/><Cube currency="HKD" rate="10.7263"/><Cube

    currency="IDR" rate="14223.55"/><Cube currency="INR" rate="66.418"/><Cube

    currency="KRW" rate="1737.55"/><Cube currency="MXN" rate="18.6785"/><Cube

    currency="MYR" rate="4.8904"/><Cube currency="NZD" rate="2.2077"/><Cube

    currency="PHP" rate="66.845"/><Cube currency="SGD" rate="2.0196"/><Cube

    currency="THB" rate="47.302"/><Cube currency="ZAR" rate="11.1715"/></Cube>

    <Cube time="2009-06-16"><Cube currency="USD" rate="1.389"/><Cube

    currency="JPY" rate="134.78"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.773"/><Cube currency="DKK" rate="7.4446"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8437"/><Cube

    currency="HUF" rate="280.08"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.5305"/><Cube

    currency="RON" rate="4.2338"/><Cube currency="SEK" rate="10.8595"/><Cube

    currency="CHF" rate="1.507"/><Cube currency="NOK" rate="8.917"/><Cube

    currency="HRK" rate="7.2676"/><Cube currency="RUB" rate="43.2647"/><Cube

    currency="TRY" rate="2.1435"/><Cube currency="AUD" rate="1.7324"/><Cube

    currency="BRL" rate="2.6887"/><Cube currency="CAD" rate="1.5612"/><Cube

    currency="CNY" rate="9.4926"/><Cube currency="HKD" rate="10.765"/><Cube

    currency="IDR" rate="14202.52"/><Cube currency="INR" rate="66.116"/><Cube

    currency="KRW" rate="1742.77"/><Cube currency="MXN" rate="18.5015"/><Cube

    currency="MYR" rate="4.8893"/><Cube currency="NZD" rate="2.1809"/><Cube

    currency="PHP" rate="66.921"/><Cube currency="SGD" rate="2.0233"/><Cube

    currency="THB" rate="47.372"/><Cube currency="ZAR" rate="11.1064"/></Cube>

    <Cube time="2009-06-15"><Cube currency="USD" rate="1.385"/><Cube

    currency="JPY" rate="136.08"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.839"/><Cube currency="DKK" rate="7.4465"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8472"/><Cube

    currency="HUF" rate="280.4"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.7035"/><Cube currency="PLN" rate="4.526"/><Cube

    currency="RON" rate="4.22"/><Cube currency="SEK" rate="10.8345"/><Cube

    currency="CHF" rate="1.511"/><Cube currency="NOK" rate="8.9055"/><Cube

    currency="HRK" rate="7.235"/><Cube currency="RUB" rate="43.2745"/><Cube

    currency="TRY" rate="2.1438"/><Cube currency="AUD" rate="1.7285"/><Cube

    currency="BRL" rate="2.6851"/><Cube currency="CAD" rate="1.569"/><Cube

    currency="CNY" rate="9.4684"/><Cube currency="HKD" rate="10.7344"/><Cube

    currency="IDR" rate="14090.25"/><Cube currency="INR" rate="66.085"/><Cube

    currency="KRW" rate="1742.1"/><Cube currency="MXN" rate="18.6982"/><Cube

    currency="MYR" rate="4.8871"/><Cube currency="NZD" rate="2.1953"/><Cube

    currency="PHP" rate="67.054"/><Cube currency="SGD" rate="2.019"/><Cube

    currency="THB" rate="47.353"/><Cube currency="ZAR" rate="11.1603"/></Cube>

    <Cube time="2009-06-12"><Cube currency="USD" rate="1.4004"/><Cube

    currency="JPY" rate="137.55"/><Cube currency="BGN" rate="1.9558"/><Cube

    currency="CZK" rate="26.655"/><Cube currency="DKK" rate="7.4457"/><Cube

    currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8538"/><Cube

    currency="HUF" rate="277.81"/><Cube currency="LTL" rate="3.4528"/><Cube

    currency="LVL" rate="0.6966"/><Cube currency="PLN" rate="4.4791"/><Cube

    currency="RON" rate="4.2001"/><Cube currency="SEK" rate="10.7555"/><Cube

    currency="CHF" rate="1.5099"/><Cube currency="NOK" rate="8.8845"/><Cube

    currency="HRK" rate="7.2582"/><Cube currency="RUB" rate="43.3717"/><Cube

    currency="TRY" rate="2.1532"/><Cube currency="AUD" rate="1.7255"/><Cube

    currency="BRL" rate="2.7099"/><Cube currency="CAD" rate="1.5708"/><Cube

    currency="CNY" rate="9.5701"/><Cube currency="HKD" rate="10.8543"/><Cube

    currency="IDR" rate="14138.5"/><Cube currency="INR" rate="66.664"/><Cube

    currency="KRW" rate="1750.32"/><Cube currency="MXN" rate="18.7584"/><Cube

    currency="MYR" rate="4.9091"/><Cube currency="NZD" rate="2.1893"/><Cube

    currency="PHP" rate="66.418"/><Cube currency="SGD" rate="2.0338"/><Cube

    currency="THB" rate="47.768"/><Cube currency="ZAR"

    rate="11.2452"/></Cube></Cube></gesmes:Envelope>'

    ;

    ;WITH XMLNAMESPACES

    (

    DEFAULT 'http://www.ecb.int/vocabulary/2002-08-01/eurofxref'

    ,'http://www.gesmes.org/xml/2002-08-01' as gesmes

    )

    --INSERT INTO @Tmp

    --OUTPUT inserted.*

    SELECT

    N'EUR' as curCodeFrom

    ,t.c.value('@currency', 'nvarchar(25)') as curCodeTo

    ,t.c.value('../@time', 'date') as cerAsOfDate

    ,t.c.value('@rate', 'decimal(19,6)') as cerExchangeRate

    FROM @x.nodes('gesmes:Envelope/Cube/Cube/Cube') as t(c);

    --;WITH XMLNAMESPACES

    --(

    -- DEFAULT 'http://www.ecb.int/vocabulary/2002-08-01/eurofxref'

    -- ,'http://www.gesmes.org/xml/2002-08-01' as gesmes

    --)

    ----INSERT INTO @Tmp

    ----OUTPUT inserted.*

    --SELECT

    -- N'EUR' as curCodeFrom

    -- ,e.c.value('@currency', 'nvarchar(25)') as curCodeTo

    -- ,t.c.value('@time', 'date') as cerAsOfDate

    -- ,e.c.value('@rate', 'decimal(19,6)') as cerExchangeRate

    --FROM @x.nodes('gesmes:Envelope/Cube/Cube') as t(c)

    --CROSS APPLY t.c.nodes('Cube') e(c);

  • DBA-640728 (10/8/2009)


    which one would be better in performance to use this approach, use openxml or use the Bulk Load of xml? i have to do an insert/update of around 450,000 rows daily from a xml file.

    Hi,

    As per my experience, you should use Bulk Load of XML in this case.

  • I have tackled this problem before. I retrieve the XML data directly from the ECB site, within a web application written in C#. The XML data is given as a string when calling the strored procedure. The XML data is then converted to XML again in the SP.

    I have used this approach in the SP:

    set @xmlData = @xmlString

    -- N.B. Not testing the XML against an XSD !

    declare @ECBRates table ( ident int IDENTITY(1,1) NOT NULL

    , dt nvarchar(20)

    , currency nvarchar(4)

    , rate money )

    ;WITH XMLNAMESPACES (DEFAULT 'http://www.ecb.int/vocabulary/2002-08-01/eurofxref')

    insert into @ECBRates (dt, currency, rate)

    SELECT

    tab.col.value('../@time', 'nvarchar(20)') As Date,

    tab.col.value('./@currency', 'nvarchar(4)') As Currency,

    tab.col.value('./@rate','float') As Rate

    FROM @xmlData.nodes('//Cube[not(*)]') As tab(col)

    ORDER BY 2,1 desc

    Now I have the data in a table I can process it the normal T-SQL way.

    I forgot to mention that I often call stored procedures form C#. Passing massive amounts of data in the form of XML to the database means just 1 call, 1 connection. The .Net overhead is reduced this way, i.e. compared to sifting through the XML and doing multiple inserts (= multiple conections). Also transaction processing within a SP is so much easier than doing it in the C# .Net environment.

  • Only your code runs about 16 seconds on my laptop versus less than a second for the version commented in my post, and cost 5 times more in plan costs on XML posted above. 🙂

    Axes travelling is a problem in your code: '../@time'.

    Try my commented version, see for yourself.

    dewit.john (10/15/2009)


    I have used this approach in the SP:

    set @xmlData = @xmlString

    -- N.B. Not testing the XML against an XSD !

    declare @ECBRates table ( ident int IDENTITY(1,1) NOT NULL

    , dt nvarchar(20)

    , currency nvarchar(4)

    , rate money )

    ;WITH XMLNAMESPACES (DEFAULT 'http://www.ecb.int/vocabulary/2002-08-01/eurofxref')

    insert into @ECBRates (dt, currency, rate)

    SELECT

    tab.col.value('../@time', 'nvarchar(20)') As Date,

    tab.col.value('./@currency', 'nvarchar(4)') As Currency,

    tab.col.value('./@rate','float') As Rate

    FROM @xmlData.nodes('//Cube[not(*)]') As tab(col)

    ORDER BY 2,1 desc

  • Thanks for the improvement. I have been testing on a server, and in both cases I see no significant difference. Good hardware has made me lazy.

    Most of this discussion has been focused on the performance within the database. I usually build C# .Net applications that interface with the database, and when you expand the scope to this area, then there are even more advantages of using XML this way.

Viewing 15 posts - 16 through 30 (of 52 total)

You must be logged in to reply to this topic. Login to reply