Code

Re: Query large XML secondary data source

nikunj_mistry — Mon, 25 Feb 2013 00:56:26 GMT

Thanks Patrick. This is what i have tried, i created a Secondary connection, which i set to fetch on demand. I wrote a FileQueryConnection which then fetches the complete xml and loads it into memory xmldocument object, this done onload. Now on my button click i query this in memory xmldocument which is very fast and almost solves my issue. But now i have below two challenges: 1. how to show this data on screen in repeating table. 2. if result set returned by query is large again, i need to provide pagination Thanks, Nikunj

Re: Query large XML secondary data source

Patrick Halstead — Sun, 24 Feb 2013 20:23:25 GMT

Hi Nikunj,

You could cache the secondary data source in the form template so that it will be part of the XSN. It will require that the XSN be copied to the local desktop whenever you update it, but 5000 items is not that huge so maybe this is acceptable. On load performance should be quite fast if everything's local.

Unfortunately, trying to use SharePoint Workspace and synchronize secondary XML file won't work because InfoPath data connections don't synch down.

Yet another option is to use SQL Express locally, but that will require some installation and additional cost to set up. We have a solution that does this but it's not free.

Query large XML secondary data source

nikunj_mistry — Sat, 23 Feb 2013 03:32:21 GMT

Hi, I am kind of newbie to Infopath. So it would be great if anyone can help me. I am using infopath 2010, solution requires just to run offline i.e. on desktop and tablets. i have xml secondary datasource, which is actually huge i.e. around 5000 items. I have set this not to load on form load. I want to give user kind of search functionality, on button click, it queries this xml and only brings the required data. Let me know how to go about it keeping performance in mind. Thanks, Nikunj