[Feature] Use SearchableScope instead PageScope

[olennikoff]

Offset search is very slow in the import, need use chunkById
More info for comparsion https://www.laravel-enlightn.com/blog/laravel-offset-vs-cursor-pagination/

[matchish]

Good idea. How would SearchableScope looks like?

[olennikoff]

It integrated into Scout /vendor/laravel/scout/src/SearchableScope.php

[matchish]

Could you share the solution?

[yocmen]

@matchish @olennikoff on my fork https://github.com/yocmen/laravel-scout-elasticsearch/tree/add-pagination-mode i have something for this, it improves a lot the way to import

yocmen@51b9edc

It uses the Cache Facade.

Note: I'm still looking for ways to improve it in large tables (3M+) + relationships eager loaded, any idea is welcomed and I can add a PR for this if needed.