Hello, I just merged Tomer's patch which removes counter_cache fields.
http://projects.theforeman.org/issues/12193 https://github.com/theforeman/foreman/pull/3596 http://guides.rubyonrails.org/association_basics.html#detailed-association-reference This was preliminary optimization, we have been able to optimize most counter calls and SQL database should now take care of all the counting. This fixes two major issues: - database deadlocks - incorrect values presented This could come with some performance penalties, but we haven't measured significant increase. On the other hand, concurrent performance when creating hosts or sending reports in parallel should be increased. If you have an instance with production data copy and you can test the next nightly build on that, please share your results in the thread (ideally before-after numbers). We are most interested in: - batch host creation - facts uploads - index pages - API/CLI commands Thanks -- Later, Lukas #lzap Zapletal -- You received this message because you are subscribed to the Google Groups "foreman-dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to foreman-dev+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.