[Engine-devel] DB performance optimization

[Liran Zelkha]

Hi all,

There is a WIP for caching and DB performance optimization. Please look at - http://gerrit.ovirt.org/#/c/14188/4

To summarize, it includes automatic caching for some business entities (*_static for instance), break up of VDS to VDS_static, VDS_dynamic and VDS_statistics, and support for batch updates.

Please share if/where you think batch updates can be used (for a usage scenario, please check InterfaceDaoDbFacadeImpl.massUpdateStatisticsForVds()).

Future tasks will include update sensitivity, better Collection caching and trying to minimize getConnection() calls.

Would love your comments and ideas. 

Thanks.