Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Power Pages - General Discussions / CRUD operation with we...
Power Pages - General Discussions
Suggested answer

CRUD operation with webapi is slow

(1) ShareShare
ReportReport
Posted on by CU31070723-0 12
Hello everybody,
 
the website that I'm building uses virtual tables from SQL. I use webapi to perform CRUD operations but I noticed that it's very slow. A patch operation to update a column of a row in a table can take from 6 to 16 seconds. Some pages need to load data from several tables when open, which can take very long if open for the first time. Is it supposed to take this long? Is it this slow because I use virtual tables? Is there any way to reduce the loading time?

Thanks in advance for your answers.
Categories:
General
  • Suggested answer
    Inogic Profile Picture
    Inogic 755 on at
    CRUD operation with webapi is slow
    Hi,
     
    When using Power Pages with the Web API to perform CRUD operations on virtual tables, the performance can indeed be slower due to the real-time nature of virtual tables and the overhead introduced by the Power Platform’s API layer.
    Below are a few steps to help reduce the load time of API events
    • Batch API Requests:
      • Group multiple API operations into a single request to reduce the number of API calls.
    • Reduce Data Fetched:
      • Use $select to return only the necessary fields and $filter to retrieve only the needed rows.
    • Caching for Read-Heavy Operations:
      • Use server-side or client-side caching to avoid frequent API calls for static data.
    • Asynchronous (Lazy) Loading:
      • Load essential data first, and fetch additional data asynchronously as needed.
    • Background Processing for Long Operations:
      • Use background jobs or Power Automate for time-consuming updates like PATCH.
    • Optimize SQL Queries:
      • Ensure efficient SQL queries by using proper indexing and avoiding complex joins.
    • Server-Side Pagination:
      • Implement pagination using $top and $skip to load data in smaller batches.
    • Monitor API Performance:
      • Use tools like Application Insights to track and analyze API performance.
    • Preload Critical Data:
      • Pre-fetch key data in the background and store it locally for faster access.
    • Optimize Power Pages Configuration:
      • Minimize unnecessary page interactions that trigger Web API calls and reduce dependencies on virtual tables.
    Hope this helps.
     
    Thanks!
    Inogic Professional Services: Power Platform/Dynamics 365 CRM
    An expert technical extension for your techno-functional business needs
    Drop an email at crm@inogic.com 
    Service: https://www.inogic.com/services/ 
    Tips and Tricks: https://www.inogic.com/blog/ 
  • Suggested answer
    FLMike Profile Picture
    FLMike 23,258 on at
    CRUD operation with webapi is slow
    There isn't any way for us to tell you.
     
    We have no access to your servers, or the networks or the gateway etc.
     
    I will see that YES virtual tables, especially if through gateways with lots of data can be slower, so you would need to enhance them to perform better
     
    If this helps please mark as yes
     
     

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,719

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans