How I speed up loading my SharePoint Online site component 6x – part 2

Last week I wrote a post about how I fix CSOM code in order to accelerate whole query execution. Final result was not that bad though still not good enough:

  • 0.8s for fetching ~500 subsites
  • 6.5s for fetching ~900 subsites recursively for whole subsites hierarchy

My aim is to fetch whole subsites hierarchy within time that is reasonable to wait (1-2s total).

In this post I show you how to achieve it – we can fetch whole subsites hierarchy in less than 2s!

Continue reading “How I speed up loading my SharePoint Online site component 6x – part 2”

How I speed up loading my SharePoint Online site component 6x – part 1

Intranet home page should contains all information that are needed in daily manner. In fact many companies use home page as a traffic node where everybody comes just to find a navigation link pointing to another part of intranet. In my current company, Findwise, we do that too. However one of our components that allows us to quickly navigate through intranet sites gets slower and slower year by year. Currently it’s loading time is almost 10 seconds! I decided to fix it or even rebuild it if needed. Especially that few weeks ago on ShareCon 365 conference I talked about SharePoint Framework in Search Driven Architecture where I described the customer case, PGNIG Termika, who saved about 600k PLN (~$165.000) per year thanks to their information accessibility improvements (information time access dropped from 5-10 minutes to 1-2 seconds). 

In this post I wanted to show you what was the problem, how I fixed it and how my fix cuts the component loading time 6 times!

Continue reading “How I speed up loading my SharePoint Online site component 6x – part 1”

How to connect SPO to AWS with AAD auth (checklist)

Not that long ago I’ve posted article about connecting from sharepoint online to azure web service using AAD authentication. I’ve checked it several times and every time I had a feeling “it’s too hard to easily follow it…”. And that’s how idea of checlist has born!
Following checklist will help you if you have any problems due to connecting from Sharepoint Online to Azure web service using Azure AD authentication.

If you’ll need life example check my code implementation here .

In this blog post I described a context for below checklist – read it if you fall into problems with CORS like:

XMLHttpRequest cannot load https://<App_URL>. No ‘Access-Control-Allow-Origin’ header is present on the requested resource. Origin ‘https://<tenant_name>.sharepoint.com‘ is therefore not allowed access.  Continue reading “How to connect SPO to AWS with AAD auth (checklist)”

Sharepoint Online to Azure Web Service authenticated with AAD

Problem

You want to communicate from Sharepoint Online with your Azure Web Application authenticated with AAD using javascript.

You configured AAD, run some AJAX call to service and received:
XMLHttpRequest cannot load https://<App_URL>. No ‘Access-Control-Allow-Origin’ header is present on the requested resource. Origin ‘https://<tenant_name>.sharepoint.com‘ is therefore not allowed access.
Continue reading “Sharepoint Online to Azure Web Service authenticated with AAD”