Slow

ldreamsl
ldreamsl Member Posts: 33
edited 2007-10-17 in NAV/Navision Classic Client
Hello everyone,
I have a question to propose.

In a Codeunit, turn on a table and export records in xml.

When start, is fast, gradually decreases its speed up to become extremely slow.

No temporary table is used, only export xml.

What might be??
God does not play dice with the universe. [Albert Einstein]

Comments

  • Darius555
    Darius555 Member Posts: 7
    What kind of table are you trying to export if it is large table try to put commit after exporting every record
  • ldreamsl
    ldreamsl Member Posts: 33
    Darius555 wrote:
    What kind of table are you trying to export if it is large table try to put commit after exporting every record

    The Commit is not useful, why not use any navision table, i use only engine for XML export.

    However, I have tried, but no effect, as expected.

    I do not know what to think.
    God does not play dice with the universe. [Albert Einstein]
  • jlandeen
    jlandeen Member Posts: 524
    I've seen the same problem with XML Ports and codeunits. I have tried working this thorugh MS support to see if they've seen it before.

    Have you tried clearing any of your XML port variable references?
    Jeff Landeen - Sr. Consultant
    Epimatic Corp.
    http://www.epimatic.com
  • Savatage
    Savatage Member Posts: 7,142
    I'll link this post - similar**
    Performance while importing large Files (~80 MByte)
    http://www.mibuso.com/forum/viewtopic.php?t=5206
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • ldreamsl
    ldreamsl Member Posts: 33
    jlandeen wrote:
    I've seen the same problem with XML Ports and codeunits. I have tried working this thorugh MS support to see if they've seen it before.

    Have you tried clearing any of your XML port variable references?

    I call functions located in a codeunit for export to XML, and after each 10.000 records , close and call a clearall.

    But this does not change things, it is as if the client navision become slower in doing everything.

    Employment memory and cpu are normal.
    God does not play dice with the universe. [Albert Einstein]

Categories