Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
How to create many objects and variables fastly.
July 8, 2019
17:03, EEST
Avatar
HOYOUNG KANG
Member
Members
Forum Posts: 11
Member Since:
April 22, 2016
sp_UserOfflineSmall Offline

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.

July 9, 2019
10:46, EEST
Avatar
Bjarne Boström
Moderator
Moderators
Forum Posts: 983
Member Since:
April 3, 2012
sp_UserOfflineSmall Offline

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.

Forum Timezone: Europe/Helsinki

Most Users Ever Online: 518

Currently Online:
23 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

hbrackel: 135

pramanj: 86

Francesco Zambon: 81

rocket science: 77

Ibrahim: 76

Sabari: 62

kapsl: 57

gjevremovic: 49

Xavier: 43

fred: 41

Member Stats:

Guest Posters: 0

Members: 681

Moderators: 16

Admins: 1

Forum Stats:

Groups: 3

Forums: 15

Topics: 1467

Posts: 6261

Newest Members:

graciela2073, sagarchau, elviralangwell4, Donnavek, Eddiefauth, DonaldPooma, fidelduke938316, Jan-Pfizer, DavidROunc, fen.pang@woodside.com

Moderators: Jouni Aro: 1010, Otso Palonen: 32, Tuomas Hiltunen: 5, Pyry: 1, Petri: 0, Bjarne Boström: 983, Heikki Tahvanainen: 402, Jukka Asikainen: 1, moldzh08: 0, Jimmy Ni: 26, Teppo Uimonen: 21, Markus Johansson: 42, Niklas Nurminen: 0, Matti Siponen: 321, Lusetti: 0, Ari-Pekka Soikkeli: 5

Administrators: admin: 1