strapi-plugin-meilisearch icon indicating copy to clipboard operation
strapi-plugin-meilisearch copied to clipboard

Suggest to change to cursor base pagination

Open pattanun-np opened this issue 7 months ago • 1 comments

Description On Get Entries Function at Life Cycle it might very slow and heary load for DB Server Because plugin use Offset based pagination I tried with 1M records sync On early page 20-30 page number speed is normal but when reach deep page like 100 number query very slow and keep incresing because Offset based need to scan all table, suggest to change to cursor base pagination

pattanun-np avatar Jul 12 '24 17:07 pattanun-np