consider defaulting arraysize to 50 for oracle; at least provide an engine-level setting for it
|Reported by:||zzzeek||Owned by:||zzzeek|
|Component:||(none)||Severity:||no triage selected yet|
|Progress State:||awaiting triage|
this because cx_oracle performs much faster with it on. If no side effects occur for BLOBs (which I bet they do), it can be a default.
unfortunately it seems like the arraysize setting must be placed before the execute(), so we can't uniformly detect BLOBs and then set (since we dont really know until result time). this *may* be yet another candidate for connection-level options (but cx_oracle should really improve this).