db performance numbers for group queries
by John Mazzitelli
For those that care :) here's information on the DB query performance testing I was doing:
For BZ 815341 ( https://bugzilla.redhat.com/show_bug.cgi?id=815341 ) I had to tweek a couple of our big group queries in order to give us proper availability data (we now can get information on the UNKNOWN state).
Because this involved some of our more complex and expensive queries, I spent a good amount of time running some DB tests both with and without my fix on both Postgres and Oracle. I used really large group sizes (probably larger than the majority of RHQ users would have in inventory) so for the majority of RHQ users I think they probably won't see much of any noticeable impact.
See my comment (and the attachment) in the BZ here:
https://bugzilla.redhat.com/show_bug.cgi?id=815341#c13
In short: as expected, it made our slow queries slower :) but it wasn't too bad. We are querying for more data, so it is to be expected the queries would be slower, but it doesn't slow it down so much as to make it much worse than what they already are. And the one query - getResourceGroupComposite - is still overall very fast (which was surprising to me).
So, I think the fix is good. If anyone wants to look at the data and comment in that BZ, feel free.
12 years
'version' child element of maven 'plugin' blocks in poms
by Ian Springer
Fyi, for Simeon and anyone else who missed this in #rhq...
(08:25:49 PM)*ips:*spinder-afk: re your antrun question, the standard
version is defined in the root pom in the pluginManagement section
(08:26:25 PM)*ips:*we still have a lot of places in sub poms where we
hard code different versions, but we should remove them
(08:26:33 PM)*ips:*i've been doing that gradually as i see them
(08:26:51 PM)*ips:*because if you don't specify any version it will
inherit the version from pluginManagement
(08:26:55 PM)*ips:*which is what we want
(08:27:18 PM)*ips:*that's pretty much what we want for all maven
plugins, not just antrun
So, in summary, the standard is to only declare plugin versions in the root pom's pluginManagement section, and not anywhere in sub-pom's.
12 years