title: How do I paginate my mysql query using AWS rds-data using boto3 and AWS-aurora?
body: <p>I am querying AWS Aurora (MySQL) serverless from AWS Lambda using Boto3. I want to query a table that has more than 10k records. My query can fetch records more than 7k. Now how can I paginate this data, on database level or Lambda level, so that I can get fewer data per page and send that small dataset to the user interface to display? I cannot send the entire dataset of 7k records.</p>
  
  <p>Here is my Python code</p>
  
  <pre><code>rdsDataClient.execute_statement(resourceArn=cluster_arn,
                                  secretArn=secret_arn,
                                  database='myTestDB',
                                  sql=sqlQuery,
                                  parameters = paramSet
                                 )
  </code></pre>
  
  <p>I am aware of the SQL query LIMIT and OFFSET but want to know if there is any other better way of doing this. Please help.</p>
  
  <p>Thanks.</p>