@@ -1208,14 +1208,27 @@ available when using queries as the results, or handle to the results, are direc
12081208
12091209Queries have access to all execution methods:
12101210
1211- ``Connection.query(sql, *parameters) ``
1212- ``Connection.query.rows(sql, *parameters) ``
1213- ``Connection.query.column(sql, *parameters) ``
1214- ``Connection.query.first(sql, *parameters) ``
1215- ``Connection.query.chunks(sql, *parameters) ``
1216- ``Connection.query.declare(sql, *parameters) ``
1217- ``Connection.query.load_rows(sql, collections.Iterable(parameters)) ``
1218- ``Connection.query.load_chunks(collections.Iterable(collections.Iterable(parameters))) ``
1211+ * ``Connection.query(sql, *parameters) ``
1212+ * ``Connection.query.rows(sql, *parameters) ``
1213+ * ``Connection.query.column(sql, *parameters) ``
1214+ * ``Connection.query.first(sql, *parameters) ``
1215+ * ``Connection.query.chunks(sql, *parameters) ``
1216+ * ``Connection.query.declare(sql, *parameters) ``
1217+ * ``Connection.query.load_rows(sql, collections.Iterable(parameters)) ``
1218+ * ``Connection.query.load_chunks(collections.Iterable(collections.Iterable(parameters))) ``
1219+
1220+ In cases where a sequence of one-shot queries needs to be performed, it may be important to
1221+ avoid unnecessary repeat attribute resolution from the connection object as the ``query ``
1222+ property is an interface object created on access. Caching the target execution methods is
1223+ recommended::
1224+
1225+ qrows = db.query.rows
1226+ l = []
1227+ for x in my_queries:
1228+ l.append(qrows(x))
1229+
1230+ The characteristic of Each execution method is discussed in the prior
1231+ `Prepared Statements `_ section.
12191232
12201233Stored Procedures
12211234=================
0 commit comments