Latest Products
Latest Products
Latest News
Latest News
Case-History Highlights
Case-History Highlights
Contact us
View our locations

TAG SEARCH - custom database indexes

I improved this screen’s performance by 1000% and so can you! (part 2)

May 22, 2015 / 0 comments / in General  / by CygNet Blog Admin

In Part 1 of my mathematically inventive “1000% improvement” tale, I introduced you to some fundamental diagnostic techniques for evaluating the potential causes of slow CygNet Studio screen performance.  Here in Part 2 of the continuing saga, we’ll dive into more details of the process by which we arrived at our Part 1 solution and introduce some useful tools for evaluating and understanding many CygNet message-based behaviors, not just this one example.

I improved this screen’s performance by 1000% and so can you! (part 1)

May 5, 2015 / 0 comments / in General  Support  WESC  / by CygNet Blog Admin

Recently, I was asked to assist with a customer support call regarding a poorly performing CygNet Studio screen.  Having just participated in Dan Snyder’s CygNet Database Service Diagnostics and Performance Tuning breakout session at this year’s WESC, I felt more than ready to take on this challenge.  Surprisingly, the actual diagnostic and remediation process required was much more involved than I expected.  My hope is that by describing, over the next several posts, the detailed process I went through to decrease the screen load time from 30 seconds to 3 seconds, you may come to understand the nuanced considerations required to craft and verify the most efficient solution for your particular needs.

Search the CygNet Blog

Subscribe to the CygNet Blog

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Tags

.NET ‘Sparkline” “Azure “Data “DDS-based “Facility “Geometric “Note “OpenStreetMaps” “Relative “SVG” 8.5.1 9.3 9.4 Ad hoc chart Alarms API ASR Authentication auto-failover automatic failover automatic service recovery beta program breakouts Bridge Bridge API broadcast browser-based Bytes Canvas Client Comm Config File Manager Configuration Context menu Controls controls” CRC custom database indexes Custom Events CygNet CygNet 9.0 CygNet 9.4 CygNet 9.6 CygNet 9.7 CygNet 9.8 CygNet messaging CygNet. Data Data Visualization DEIDs Depot Designer device mapping Diagnostics disaster recovery Dynagraph EAC EIE email emitter” Enhanced Alarm Configuration Excel Facilities” failover feedback Files first look FMS FWRD Get Latest Get New GitHub gns Grid” group group grid Heat Map HMI HSS IoT iPhone Job Runner Maps” Measurement Mobile Navigation OAuth ODBC On-demand chart OPC UA Polling recovery redundancy reference facilities Reference Packages Release Remote replication Report Module Samples SCADA screen performance Scripting Security Shapes” slides Sniffer SQL Server survey Tabs Tech Bulletin Template TFA Thin Web Client Token Tools transactions” Tree Map trend Troubleshooting Two-factor UIS video View Group web-based WESC 2016 WESC 2018 WESC 2020 WESC2019