search

manticoresoftware / manticoresearch-php

Official PHP client for Manticore Search
MIT License
167 stars 32 forks source link

Correct pagination #179

Closed tzukav closed 9 months ago

tzukav commented 9 months ago

Hello guys, Is there any "search_after" option like the one from elasticsearch? I want to paginate over millions of documents, but you know, the LIMIT , from sql is not great idea for a big database. I don't know how manticore sort rows different than mysql, but for mysql LIMIT just doesn't work. In elastic i use "search_after" to avoid querying all the previous "rows", and it works like a charm. This feature is the only thing i need to move away from elastic. Cause i really like what you guys did here. An alternative would be lt: last identifier to reproduce the search_after, but will it really work as expected / like in elastic in terms of treating the previous rows? Didn't find anything related in the docs. Thanks.

tzukav commented 9 months ago

nvm, should i have posted in the database repo. sorry