@Mark81 Even in JavaScript you have two models, you just don't typically think of it that way: model 1: the database, model 2: the results on the client side.
Here, you have two models: 1 - the database, 2 - the QML side.
So what you need to do is create a paginated model using LIMIT/OFFSET queries.