[Optimization ] Do not open transaction for readonly query

Open/abort/commit transaction would increment transaction id which is a burden unnecessarily. In addition, it spams the notification log and make CachedStore (and of cause other components rely on notification log) harder to catch up.