High memory usage & duration during app installation.

[clydesantiago]

Expected Behavior

Optimize query for faster installation of App.

Current Behavior

When you have 100,000+ users, installation process slows down because of redudant query.

Steps to Reproduce

1. Use https://laravel.com/docs/8.x/telescope for monitoring requests.
2. Install Shopify App on you shopify
3. Inspect queries on Laravel Telescope

Context

We are currently using ^12.0 of osiset/laravel-shopify. We also tried upgrading to latest version. The result is the same.

• Package Version: ^16.0
• Laravel Version: ^7.0
• PHP Version: 7.4
• Vagrant

Failure Logs

Memory usage is 449 MB and Duration is 11 seconds because of query below. Note: this is 100,000+ users

[clydesantiago]

@osiset pull request for the fix #705

[gnikyt]

Thank you, merged. Will push a patch.