Eli Mesika has posted comments on this change. Change subject: core: Sometimes getting exception when trying to preview snapshots (#836162) ......................................................................
Patch Set 2: (1 inline comment) .................................................... File backend/manager/dbscripts/snapshots_sp.sql Line 144: WHERE vm_id = v_vm_id recommending adding an index on the vm_id column Since we have 99% db read activity , we can freely add indexes to improve the read operations , affect on update/insert operations is negligible -- To view, visit http://gerrit.ovirt.org/5825 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: I07ec66f6c725827526250a03e04f133783ed7270 Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Michael Kublin <mkub...@redhat.com> Gerrit-Reviewer: Eli Mesika <emes...@redhat.com> Gerrit-Reviewer: Michael Kublin <mkub...@redhat.com> Gerrit-Reviewer: Mike Kolesnik <mkole...@redhat.com> Gerrit-Reviewer: Omer Frenkel <ofren...@redhat.com> Gerrit-Reviewer: Yair Zaslavsky <yzasl...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
