arraysize

Overview

This cursor value (read/write) is the number of rows that fetchmany() reads per call. The default is 1.

See also: MariaDB Connector/Python 1.1 and in 1.0

EXAMPLES

Override the number of rows that the next fetchmany() will fetch:

import mariadb

conn = mariadb.connect(
    host = 'localhost',
    user = 'root',
    password = 'secret',
    )

cursor = conn.cursor()
print(cursor.arraysize) # Prints: 1

cursor.arraysize = 5
print(cursor.arraysize) # Prints: 5

CHANGE HISTORY

Release Series

History

1.1

  • Present starting in MariaDB Connector/Python 1.1.2.

1.0

  • Present starting in MariaDB Connector/Python 1.0.0.