17:03, EEST
April 22, 2016
I developed the interoperability related software using prosys opc ua sdk.
This software creat nodes when user open project file which is xml format for building address space.
My customer (user) create very large project file. It has about 1 million nodes!.
So when lading this project file, it takes more than 5 minutes.
Is there any solution to improve lading speed?
For example, database support bulk insertion or long transction approach.
I want to load in a minutes.
Thanks.
10:46, EEST
April 3, 2012
Hi,
Well with that huge number of nodes I would say 5 minutes (you didn’t say how much more than 5mins however) is already really good, generally I would expect a lot longer..
Assuming we are talking about NodeSet2 format XMLs and normal loading to the server, this might not be the best design in general, as that would load them into memory and if you have that much nodes then usually at some point running out of memory starts to be problem. A database might be better in this case.
You might need to build your server the MyBigNodeManager way (see the SampleConsoleServer example), then the data would not be as UaNodes and is basically up to you how you will load or store it. Still if the input to your application is the NodeSet2 file with a million nodes even just processing that might take a while..
Note, if that was done with 3.x of the SDK, you could try with 4.x, it might be slightly faster (only a bit and even then depending on the number of tags in the model), but with that number of nodes it might do some difference.
If you can, this could help (if you are not going the MyBigNodeManager way):
Check that you have defined each Reference only once in the model file. SDK automatically creates the reference to both directions even with one definition. If it is defined in both directions in the model, then SDK needs to do an extra step per reference when loading. This step is directly related to the number of references the node already has.
Most Users Ever Online: 1919
Currently Online:
15 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Heikki Tahvanainen: 402
hbrackel: 144
rocket science: 88
pramanj: 86
Francesco Zambon: 83
Ibrahim: 78
Sabari: 62
kapsl: 57
gjevremovic: 49
Xavier: 43
Member Stats:
Guest Posters: 0
Members: 736
Moderators: 7
Admins: 1
Forum Stats:
Groups: 3
Forums: 15
Topics: 1524
Posts: 6450
Newest Members:
kristiewinkle8, rust, christamcdowall, redaahern07571, nigelbdhmp, travistimmons, AnnelCib, dalenegettinger, howardkennerley, ThomassnismModerators: Jouni Aro: 1026, Pyry: 1, Petri: 0, Bjarne Boström: 1026, Jimmy Ni: 26, Matti Siponen: 346, Lusetti: 0
Administrators: admin: 1