Slow

ldreamsl

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??

Darius555

What kind of table are you trying to export if it is large table try to put commit after exporting every record

ldreamsl

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.

jlandeen

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?

Savatage

I'll link this post - similar**
Performance while importing large Files (~80 MByte)
http://www.mibuso.com/forum/viewtopic.php?t=5206

ldreamsl

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.