Cursor tuning to make sure it returns results

[Jaymon]

SQLite has an arraysize that returns the next set of rows when iterating through a cursor, by default this is 1, but I'm wondering when doing Query.all() if we should set this value to like 500. I'd need to look into how Postgres handles this.

• https://docs.python.org/3.11/library/sqlite3.html#sqlite3.Cursor.fetchmany
• https://www.psycopg.org/docs/cursor.html#cursor.arraysize

[Jaymon]

https://stackoverflow.com/a/125140/5006 - You need to set the arraysize attribute before calling execute