Hello Michael, Thank you for looking at this and improving it further. I have pulled the latest patches into my branch and rebuilt the packages for both java and schema. I then performed an update of these new packages and performed a schema update on the DB but it seems the new arch ID for the view didn't get created. Is there anything I need to do in order to get this created to allow the new queries to run? Thank you for your time and have a great day!
Regards, Jeremy -----Original Message----- From: spacewalk-devel-boun...@redhat.com [mailto:spacewalk-devel-boun...@redhat.com] On Behalf Of Michael Mraka Sent: Thursday, February 20, 2014 4:05 AM To: spacewalk-devel@redhat.com Subject: Re: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages Jeremy D Davis wrote: % Attached you will find the patch as per the documentation % https://fedorahosted.org/spacewalk/wiki/GitGuide . Sorry about all the % emails and not following documentation. ... % Hello Spacewalk Developers, % % After asking the last question I decided to go ahead and make a change % of my own to see if I can improve performance. I was able to improve % the query by at least 6 seconds faster. The old query was taking about % 6101 ms to finish where I my query takes about 161 ms. Much % improvement. Please let me know if there is anything I need to change. % If everything looks good please let me know how I can get this added % for the next release of Spacewalk (Prefer 2.1). Hello Jeremy, Thank you for your patch. I've reviewed it and completely agree with you. Moreover looking into this query I found out some more places which can be optimized so I did even more complex rewrite of it. And there was also very similar query for list on UpgradableList.do page. Both changes are in 2a11191e20de5d0fa751f61fd59e82d903242238 so you can check it. Regards, -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
