# Buffered Cursors for Connector/Python
+ `Connector/Python` Query results are not buffered by default
+ Rows are not fully fetched from the TiDB server until the fetch is completed, such as calling `fetchall()`
+ You must read all the rows in the result set before executing another statement on the same connection. Otherwise, your program will throw an internal error: `Unread result found`
+ Enable buffers:
  + `cursor = conn.cursor(buffered=True)`
  + `conn = mysql.connector.connect(buffered=True)`
--------------------------------------------------------
Buffering the result set on the client is useful in certain situations, such as when you want to use multiple cursors per connection and you want to traverse each one in an interleaved fashion. For example, you might need to determine if the value of a specific column in the first row of the result set is equal to that of the same column in the last row.

Be aware that with bigger result sets, the client uses more memory. Use a buffered cursor only if you are certain that most result sets are small.