Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

Join our "Ask Me About" community webinar on May 20th at 9 AM CET and 5 PM CET to explore cybersecurity and monitoring for Data Center and edge IT. Learn about market trends, cutting-edge technologies, and best practices from industry experts.
Register and secure your Critical IT infrastructure

Sluggish Value Item Creation/Updates

SmartConnector Forum

Schneider Electric support forum about SmartConnector applications for integration of other building management systems (BMS) into EcoStruxure Building Operation.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • EcoStruxure Building
  • SmartConnector
  • SmartConnector Forum
  • Sluggish Value Item Creation/Updates
Options
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Experts
User Count
JeffBowman
Sisko JeffBowman Sisko
164
ardak
ardak Schneider Alumni (Retired)
34
sesa180908_brid
Commander sesa180908_brid Commander
34
mike_meirovitz
Commander mike_meirovitz
21
View All

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Back to SmartConnector Forum
Lydia
Lieutenant | EcoXpert Master Lydia Lieutenant | EcoXpert Master
Lieutenant | EcoXpert Master

Posted: ‎2021-03-25 05:55 AM

0 Likes
3
1253
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2021-03-25 05:55 AM

Sluggish Value Item Creation/Updates

One of my company's clients have around 3,500 points (or value items) which communicates between our company's software (CS) and Struxureware (SX). I've built a Smart Connector processor to communicate between the two. When the number of points are relatively small, my processor performs adequately. As the number of points increase, however, so does the time it takes to initialize/update container items and value items. Of course, this makes sense: As the number of points increase, so does the time it takes to perform all necessary operations. The problem, however, is that updating all value items can take minutes at a time. This time delay is unacceptable for our use, unfortunately. 

 

I have performed numerous tests on my processor, and the results are as follows:

- Obtaining container information from CS - 2 seconds

- Obtaining item information from CS - 2 seconds

- Processor item creation/calculations - 0-2 second(s)

- Creating containers in Struxureware - 12-15 seconds

- Creating/Updating items in Struxureware - 1.5-3.5 minutes

 

The majority of the operating time is during item creation and updates. 

Simply commenting out the following line of code during the execution of the first run of the processor lets the processor fully run in <20 seconds.

DataAdapter.AddValueItem(altId, name ?? altId, description, type, writeable, forceable, defaultState, unit, parent);

 

I've been trying to think of different ways to counteract this problem such as 1) making the method for item creation/updates async, place the method as an action in a list of tasks, and start those tasks as separate threads (Didn't work, received errors), remove "async" from the item creation/update method and run those tasks as synchronous (which did not improve performance), and creating value items and appending those items directly into the EwsServer.ValueItems IEnumerable List (which did nothing).

 

I don't know what I can do to make item (and less importantly, container) creation/updating faster. 

Tags (18)
  • Tags:
  • connector
  • container
  • create
  • creating
  • creation
  • english
  • execution
  • fast
  • item
  • processor
  • slow
  • smart
  • smartconnector
  • test
  • testing
  • tests
  • updates
  • updating
Reply
  • All forum topics
  • Previous Topic
  • Next Topic
Replies 3
JeffBowman
Sisko JeffBowman Sisko
Sisko

Posted: ‎2021-03-25 07:18 AM

0 Likes
2
1248
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2021-03-25 07:18 AM

Hi @Lydia ,

 

So you are creating 3,500 objects in a Smart Connector EWS server? During the creation of these objects and updating their values it is taking longer than what is expected?

 

A couple questions.

 

- Isn't the creation of the objects only a one time thing on the initial run? So this 'delay' should only be on initial creation. I am curious as to why this is not ok. Before I go and tell you how to insert all the new objects in a single transaction (which is risky because there are many checks that are not done when doing it this way, I want to understand the reason for this problem because there might be another option)

- As far as value updates specifically, there are ways to speed this up. Mainly you can turn off AutoCommit and commit all the value changes at once using something like the code below. (NOTE: This only works for property changes, and NOT object creation).

 

DataAdapter.AutoCommit = false

foreach (var item in itemsToUpdate)

{

DataAdapter.ModifyValueItemValue(item, value, state);

}

DataAdapater.CommitChanges();

DataAdapter.AutoCommit = true;

 

Best Regards,

 

-Jeff

 

 

Tags (1)
  • Tags:
  • english
Reply
Lydia
Lieutenant | EcoXpert Master Lydia Lieutenant | EcoXpert Master
Lieutenant | EcoXpert Master

Posted: ‎2021-03-25 10:04 AM . Last Modified: ‎2021-03-25 10:13 AM

0 Likes
1
1245
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2021-03-25 10:04 AM

I apologize for the confusion. Since it is only performed once, item creation is not a very large problem. The lag in updating the items is.

 

My processor already has AutoCommit turned off. I changed my processor back to its original state where it performs all the updates and commits the changes once at the end of the processor run.

 

These are the times I have right now:

- First run: 5.6 minutes

- First run + Second run: 7.7 minutes

 

As you can see, the second run - which updates all the containers and items - takes 2.1 minutes. I can scale it back to 1.8-1.9 minutes by not checking any changes to containers. But needing 2 minutes to update all points (approx. 30 items/sec) still takes awhile simply due to the number of points.

 

Is there anything else I can do to make the processor run faster?

Tags (1)
  • Tags:
  • english
Reply
JeffBowman
Sisko JeffBowman Sisko
Sisko

Posted: ‎2021-03-25 10:32 AM

0 Likes
0
1239
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2021-03-25 10:32 AM

Hi Lydia,

 

I think it would be best if i could perhaps see the code. Feel free to email me at jeff.bowman@se.com, I am available the rest of the afternoon today, or we can schedule another time for me to take a look if you are interested.

 

Best Regards,

 

-jeff

Tags (1)
  • Tags:
  • english
Reply
To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of