Code

Re: Faster way to clear a node

Matt Faus — Sun, 29 Jul 2007 16:54:00 GMT

Unfortunately, you will have to implement paging on your own. We have discussed this countless times on the forums - try searching around a bit. We also have a few blog posts that cover this, I think.

Re: Faster way to clear a node

moestavern — Sun, 29 Jul 2007 16:45:41 GMT

Hi Matt,

does the repeating table control have the ability to do paging, or do I need to use views ?

I am using Infopath 2003.

cheers

moe

Re: Faster way to clear a node

Matt Faus — Fri, 27 Jul 2007 16:04:55 GMT

Yes, 1100 nodes on any single InfoPath view will cause huge performance hits. You should use paging to only show 20 rows at a time, or when you are deleting, switching to another "Deleting" page while the delete operation runs, and then switch back after it is done.

Re: Faster way to clear a node

moestavern — Fri, 27 Jul 2007 12:16:35 GMT

I Played around a little, removing 100 child nodes still has acceptable performance (a couple of secs), however deleting 300 (or even 1100) nodes takes several minutes with a white-screen-non-responding infopath ;-(

Re: Faster way to clear a node

moestavern — Fri, 27 Jul 2007 11:53:44 GMT

Hi Matt,

yes,

allTheNodes.removeAll();

is valid JScript.

However, the behaviour is the same. Seems to me as if

allTheNodes.removeAll();

internally performs the same for loop with removeChild that I did before.

Cheers

Stefan

Re: Faster way to clear a node

Matt Faus — Fri, 27 Jul 2007 11:31:15 GMT

Hi moestavern,

Yes. I'm not sure the exact syntax in JScript, but the IXMLDOMSelection class has a removeAll() method that I always use when doing something like this. I haven't run numbers or encountered a problem like this, but it should be faster.

Try this:

allTheNodes.removeAll();

Faster way to clear a node

moestavern — Fri, 27 Jul 2007 06:31:44 GMT

Hi all,

my users search for products in a database, and I want to allow my user to clear the repeating table of search results. So I have a button with this code:

// now clear the query results table
objSource = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields" );
var allTheNodes = objSource.selectNodes("//d:Products");
for (var i=0; i<allTheNodes.length; i++) {
Item = allTheNodes.item(i);
objSource.removeChild(Item);
}

This works fine if my repeating table showing the products only has a couple of entries. Once the number of entries is huge (100+, I would say), INFOPATH.EXE consumes 50% CPU for minutes, and most of the time I have to kill the process since it never seems to return.

Is there a faster and mroe performant way to remove all child nodes ?

Cheers

moe