Choosing Between VARCHAR, NVARCHAR, CHAR
Choosing Between VARCHAR, NVARCHAR, and CHAR in SQL Server: A Detailed Guide When working with SQL Server, one of the fundamental aspects of database design is selecting the correct data….
Tag: Performance
Archiving old web pages
Archiving old web pages in Power Pages (formerly Power Apps Portals) is essential for managing and retaining historical content while optimizing the performance and user experience of your portal. As….
Enabling Application Insights telemetry
Application Insights is a powerful tool from Azure that allows you to monitor the health, usage, and performance of your Power Pages portal. Enabling telemetry provides insights into user behavior,….
Using Indexed tables for better data loading
Indexed tables significantly enhance performance and responsiveness in Power Pages by allowing faster querying and data retrieval from Dataverse. Proper indexing ensures efficient handling of large datasets, especially in Entity….
Minifying JavaScript and CSS
Minifying your JavaScript and CSS helps reduce file sizes, improve load times, and enhance overall portal performance. In Power Pages, since you’re often working with Web Files or referencing external….
Avoiding unnecessary server calls
Reducing server calls not only improves the performance and responsiveness of your Power Pages site but also enhances scalability and reduces Dataverse API consumption. Here’s how you can avoid unnecessary….
Image optimization for faster load
Optimizing images is critical for improving the performance of your Power Pages and ensuring faster load times. Large, unoptimized images can significantly slow down page rendering, impacting user experience and….
Caching strategy for Web Templates
Caching is an essential aspect of improving the performance and scalability of web applications, including those built on Power Pages. When implementing caching for web templates, it’s crucial to balance….
Digest cycle triggering multiple times unnecessarily
Digest Cycle Triggering Multiple Times Unnecessarily in AngularJS In AngularJS, the digest cycle is the process where the framework checks all the model values to see if any have changed….
What happens after AngularJS reaches end-of-life?
After AngularJS reaches its end-of-life (EOL), several key consequences and considerations will affect developers and organizations still using the framework. Here’s what happens: 1. No More Official Updates or Support….