add support for streaming results to requestor; add support for commit/optimize/rollback