How to get pagination of not all records from the database?

Question

Laravel

When paginating, all records are taken from the database. But you need to take for example 500 records, and the following code does not work. Tell me how to be.
Note::query()
->where ('published', 1)
->take (500)
->paginate(100);

Answer 1

During pagination, N records are retrieved from the database, which are specified in paginate(N)
What do you want to do? To not be able to scroll to the latest entries?
Then filter by some parameter so that it gives out the necessary records, and not all.

Answer 2

Try using the total method