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  Software Conference  Support  / 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” “.NET “64-bit” “Allen “Azure “Canvas” “CygNet “Data “Database “DDS-based “Dispatch” “DNP3 “Facility “FWRD” “Geometric “Historical “HMI “IoT “IoTCygNetLink “Lufkin “MQTT “Note “OpenStreetMaps” “Real-time “Relative “Replication” “SCADA” “Security” “SVG” “Telerik” “Thin “TLS “Topic “Totalflow “Weatherford 1.2” 8.5.1 8” 9.3 9.4 9.9” Ad hoc chart Alarms API API” API”” Appsettings ASR Authentication auto-failover automatic failover automatic service recovery beta program Bradley breakouts Bridge Bridge API broadcast browser-based Bytes Canvas CIP Client Client” Clients” Comm Config File Manager Configuration Context menu Controls controls” CRC custom database indexes Custom Events CVS CygNet CygNet 9.0 CygNet 9.4 CygNet 9.6 CygNet 9.7 CygNet 9.8 CygNet messaging CygNet. Data Data Visualization Data” DEIDs Depot Designer device mapping Diagnostics disaster recovery Dynagraph EAC EIE EIE” email Emerson emitter” Enhanced Enhanced Alarm Configuration Excel Facilities” failover feedback Files first look FMS Full FWRD Get Latest Get New GitHub gns Grid” group group grid Heat Map HMI HSS IoT iPhone Job Runner json Link Link” Maps” Measurement Measurement” Messaging” Mobile Mode” MQTT Navigation OAuth ODBC On-demand chart OPC OPC UA Polling recovery redundancy reference facilities Reference Packages Release Remote replication Report Module SAM Samples SCADA screen performance Scripting Security Server” Shapes” slides Sniffer SQL Server Subscriptions” survey Sync” Tabs Tech Bulletin Template Test” TFA Thin Web Client Token Tools transactions” Tree Map trend Troubleshooting Two-factor UA UIS video View Group Web web-based Well WESC 2016 WESC 2018 WESC 2020 WESC2019