4D Summit: [4D Summit 2018] Advanced Troubleshooting: Slowdowns in 4D Applications [EN]
PRODUCT: 4D | VERSION: 16 | PLATFORM: Mac & Win
Published On: May 3, 2018
This technical article is currently restricted to 4D Summit attendees and Partners Only. Login with your Customer account to have full access to this article!!!
One day you start receiving complaints that your beautiful 4D application is experiencing slowdowns. This happens at random times through the day and you can’t reproduce it in-house. It all worked well before and you do not know where the problem is. Is it a new method you just added or is it more users than usual? Maybe one of the users doing something completely unexpected?
I will show you various ways to troubleshoot the slowdowns based on our decade of experience of scaling up and troubleshooting 4D Enterprise servers from small single-school applications to large district-sized 4D installations. In a matter of few minutes, you will learn our full collection of tips & tricks that took us months of toil to discover.
Agenda
- Wonderful Debug Logs in 4D – how and when to use
- Techniques to makes sense of Debug Logs and find bottlenecks
- Real-time monitor in 4D v16
- Database measures
- Process monitor
- Information Component
- Three main types of Slowdowns and how to troubleshoot them
- Real-life examples of findings and fixing slowdowns with 4D Debug Logs and RTM
- Crazy loops
- Fast-typing users
- Long SQL queries
- Long 4D queries
- Wireshark – what to use in rare cases when 4D Debug Logs do not help
- Q&A
Presented by: Denys Storozhuk • PowerSchool Group LLC