I moved exoscale/seql to latest next.jdbc and honeysql, thanks for the great work @seancorfield, a lot of further simplification are now possible

anyone have good ideas about how to configure a statement/ResultSet's fetchSize? Good heuristics for a single decent value?

Interestingly enough, I was reading something about psycopg the other day. Their default is 2000 rows...

the default value of 2000 allows to fetch about 100KB per roundtrip assuming records of 10-20 columns of mixed number and strings; you may decrease this value if you are dealing with huge records

I would experiment, start with something similar and go up/down from there

In one of my applications, I had a fetchSize of 5000.