Xlate from Hrl to Xml and Outbound validation question

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf Xlate from Hrl to Xml and Outbound validation question

  • Creator
    Topic
  • #53771
    TorfinnK
    Participant

      Running Cloverleaf 5.7 Rev.3 on Windows 2003, upgrading a site from 5.3

      The question is about output validation.

      The Xlate are from a Hrl to a Xml.

      The input file has from a few hundred lines up to 12

    Viewing 3 reply threads
    • Author
      Replies
      • #78884
        Elisha Gould
        Participant

          We had a similar issue when changing from 5.6 to 5.8 so I’m guessing the change was done in 5.7.

          In our case it went from around 5 minutes up to 30+ minutes to process a large xml file.

          The issue appears to be that cloverleaf will iterate through the entire xml structure to the node your working on whenever something is read/written, so as the structure gets larger it gets exponentially slower.

          I’m guessing that it is reading/writing from disk as well rather than memory, so that is the cause of the slowness.

          We ended up using a basic tcl xml parser to read in the xml to bring it to a reasonable timeframe to handle the large xml documents.

          Our vendor raised a ticket with Infor to have a look at this at the start of June, but I’m not sure on the status of the ticket.

        • #78885
          Robert Kersemakers
          Participant

            I’m just curious. Are you using an XSD to define your (outbound) XML? And if so: are there any ‘maxOccurs = 99’ or ‘maxOccurs = 9999’ in the XSD? Try replacing it with ‘maxOccurs = unbounded’.

            I have a feeling that when you use ‘maxOccurs = 99’, Cloverleaf will always go to through the repetition 99 times, whether it’s filled or not. With ‘maxOccurs = unbounded’, Cloverleaf will check whether another repetition is necessary. Just a gut feeling though.

            Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

          • #78886
            TorfinnK
            Participant

              Hi

              It

            • #78887
              Elisha Gould
              Participant

                Hi Rob,

                All ours have unbounded or 1.

                The issue we have is that we using tcl to call grmfetch on each index of the repeating xml structure.

                I couldn’t find an iterate feature to grab the next index, so it is being called with the index id.

                ie SOAP-ENV:Envelope.SOAP-ENV:Body.tns:Structure($id)…..

                This causes it to go through the entire structure up to that point for each index. ie if you search for index 1000 it goes through 1000 index’s to get to that point.

                So for my case with around 30000 indexs it goes through around 450 million iterations.

                It appears that something changed in the grm code to increase the processing time by 5-6x the amount.

            Viewing 3 reply threads
            • The forum ‘Cloverleaf’ is closed to new topics and replies.