Improving SQL Join Performance with External Systems | The Low-Code Café #195

In this episode of Low-Code Café, hosted by Dale Warner from Plant an App, the discussion centers around enhancing SQL join performance, focusing on technical insights and hands-on demonstrations. The episode kicks off with an introduction to hot fixes and new support features, including paid assistance and hands-on support. Dale explores automation tasks, their impact on performance, and offers solutions such as the 'skip if running' feature and start time staggering. The episode also highlights a new speech-to-text feature on the Campfire website. For the main topic, a simulated test scenario involving an external CRM system and Plant an App's entity table is presented, examining performance implications and the role of automatic indexing. Furthermore, the use of AI for SQL query performance tuning is showcased, alongside discussions on custom index responsibilities and the potential downsides of excessive indexing. 00:22 - Introduction and Overview 02:16 - Hot Fixes and Support Features 02:24 /// Explanation of hot fixes 04:46 /// Introduction of new support features 03:17 /// Demonstration of installing hot fixes 06:36 - Automation and Performance 07:50 /// Demonstration of 'skip if running' feature 10:55 /// Explanation of staggering start times 13:51 - Campfire Website and Speech to Text Feature 14:30 /// Demonstration of the speech to text feature 15:57 /// Encouragement to engage in low code campfire 16:47 - Improving SQL Join Performance with External Systems 17:42 /// Explanation of the simulation setup 18:05 /// Discussion of the performance examination 17:58 - Introduction to Plant an App Entity Table 19:15 /// Demonstration of SQL console 20:12 /// Creation of CRM contacts table 20:56 - Populating the Entity Table 21:09 /// Populating the CRM contacts table 21:32 /// Demonstration of data in the table 26:21 /// Joining the external system with contact history 31:46 - Performance Analysis 33:07 /// Demonstration of SQL Server Management Studio 35:40 /// Baseline performance measurement 37:18 - Understanding Plant an App's Automatic Indexing 38:49 /// Demonstration of how indexing improves performance 39:14 /// Discussion on the impact of indexing on data retrieval 41:42 - Using AI for SQL Performance Tuning 42:23 /// Demonstration of AI providing recommendations 48:52 /// Discussion on the impact of AI recommendations on performance 43:52 - Understanding Custom Index Behavior in Plant an App 45:21 /// Discussion on the responsibilities of using custom indexes 53:14 /// Warning about the potential negative impact of adding too many indexes --- Links for this episode Register in advance for Low-Code Campfire: https://us02web.zoom.us/meeting/register/tZAqfu2rqTgtG9yVpLeC_fWGZWjKztUX3S2_ Webinar recordings - make sure to subscribe - https://www.youtube.com/plantanapp Community Portal - https://community.plantanapp.com/ Webinar Feedback form - http://bit.ly/lowcodecafefeedback Documentation: learn.plantanapp.com/docs/current/understanding-custom-index-behavior --- The Low-Code Café is our monthly community webinar & work session where we share ideas, and updates, and even build working applications together, from the very simple to the very complex, with the help of the Plant an App Platform. RSVP for the next edition here: https://us02web.zoom.us/webinar/register/3015952938279/WN_Y0OUx5njQFatTEMCk3B0yg Learn more about the fastest way to build powerful web apps - https://www.plantanapp.com/ Every webinar, we will build apps together and have a great time. Besides specific topics and getting together with the community, we also have our regular segments to showcase the latest updates, tips & tricks. - Product Roadmap Updates, with Bogdan Litescu, Head of Product Development - Stories from the Trenches, with Dale Warner, Head of US Support - Hands-on Low-Code, with members of the Product Development team - Bogdan Litescu, CEO & Founder, is the one to start the show, and our regular webinar host Be sure to hit the like button and subscribe to the channel for more low-code insights and updates.