[Python] How to paginate large result sets in Python?

I'm using a basic SELECT * and fetching all rows, but I'm worried about performance if my container grows large. Is there a LIMIT/OFFSET equivalent in GridDB’s query language or another way to handle pagination?

query = container.query("SELECT *") rs = query.fetch()

for row in rs: print(row) # Works, but what if I have millions of rows?

Continue reading...