[ZoomAccounts] Fix N+1 issue in availability field

[thenamankumar]

To improve the performance of the query by reducing the no. of separate db queries. Need to batch the availability status check queries in zoomAccount.availability.

Problem: N+1
Solution: Dataloader
Learn: https://www.youtube.com/watch?v=OQTnXNCDywA

[coderrsid]

Can i work on this @hereisnaman ?

[thenamankumar]

@coderrsid sure, I am assigning it to you. Let me know if you need any help.

[coderrsid]

Although it'll be a big implementation. Sure i'll see what i can do.

[coderrsid]

@hereisnaman How exactly the query is reaching N+1 issue. I am not able to quite find that!

[thenamankumar]

@coderrsid
For the query:

query FetchZoomAccounts {
  ZoomAccounts(availableDuring: ...) {
    id
    availability(dateTimeRange: ...)
  }
}

The number of sql queries will be:
1 for finding the list of N zoom accounts.
N queries to find the availability of each of them.

[coderrsid]

Hey naman, should i wait for the another similar issue for CalendarInvite as he also added dataloader package, so i don't want that package version conflicts happen??

[thenamankumar]

Hey naman, should i wait for the another similar issue for CalendarInvite as he also added dataloader package, so i don't want that package version conflicts happen??

That is a 1 line change, how hard will it be to resolve it even if that comes?