Skip to Content.
Sympa Menu

grouper-dev - Re: [grouper-dev] Possible performance issue with HSQLDB...

Subject: Grouper Developers Forum

List archive

Re: [grouper-dev] Possible performance issue with HSQLDB...


Chronological Thread 
  • From: Michael Douglass <>
  • To:
  • Subject: Re: [grouper-dev] Possible performance issue with HSQLDB...
  • Date: Tue, 16 Oct 2018 14:37:17 -0400
  • Ironport-phdr: 9a23:+/hUdBJmIcdkuzKORNmcpTZWNBhigK39O0sv0rFitYgeL/7xwZ3uMQTl6Ol3ixeRBMOHs60C07KempujcFRI2YyGvnEGfc4EfD4+ouJSoTYdBtWYA1bwNv/gYn9yNs1DUFh44yPzahANS47xaFLIv3K98yMZFAnhOgppPOT1HZPZg9iq2+yo9JDffwdFiCChbb9uMR67sRjfus4KjIV4N60/0AHJonxGe+RXwWNnO1eelAvi68mz4ZBu7T1et+ou+MBcX6r6eb84TaFDAzQ9L281/szrugLdQgaJ+3ART38ZkhtMAwjC8RH6QpL8uTb0u+ZhxCWXO9D9QLYpUjqg8qhrUgflhjoZOT438G/ZicJ+g6xUrx2juxNxzJXZYJ2XOfdkYq/RYd0XSGhHU81MVyJBGIS8b44XAuQGPOZXs4n9qEEQohu6GAKiCuTvyiJHhn/yx6I6yP8hGhzB0QwlAt0Ot2nUrNrxNKgISuC117LFzS7bb/NWxzj98onIfQw7rvGIQb1wdsTQyUY1FwPCk1WQsZbpMC+S1uQIqmWW6fdrW+G3i2M/tQ18oySjy8Uph4nHhY8a0UzI+CB2zYs2JNC1R0t2bcC4HJZVsiyXNJV6Tdk6T2xqtys20L8LtYKhcCUJ1Jgr3R/SZv2BfoOV+BzsTvyRLi19hH99eLKwmRKy8U+4x+35TMa00VJKojNcktnQq3wBzhPS58uZRvRn5Euh1jGP1wfc6uFAP084j7bUK5kkwrIol5oTt1rMHjPulUnojaKaakcp9+2m6+nkebrqupqROoB3hwz/Pakjn9KzDfg9PwULXGWX5/6z2KXm/ULjQbVKivM2krPesJDfPckbo7O2AwhI0oYs7xawFSym0M8DkHkcNFJFeAyIj5LoO17SOv/4Ceuwg1OikTdk3fDGOaDhAo3XInffl7fheK5x61RAxwor0dBf+5VUB6kOIPLpXU/xqcTYAQEjMwCt3unoFst925gaWWKOGa+ZLLjSvUGS6uIuJemMeJEauCz7K/c7+/7ik2U1lkEAcqm0jtMrbyW3BPN7O0iDJHbhnP8AF3sHpAwzULashVGfAhBJYHPneqM35jg2DMqKCprMQom2m/TV2Su8A5JSb3tdIkuUEXrydo6NX/wLdy2IJdJ51DcDUO7yGMcayRiyuVqimPJcJe3O93hAuA==

I mentioned this a long time ago - I tried stepping through the entire call but could not find the issue.

I don't believe it's a performance issue as such with hsqldb. I tried the queries directly and they return almost immediately.

It happens in a number of places - I worked on developing an app using grouper and debugging was a pain because of these long delays

I'd be inclined to suggest moving to h2.

It will certainly look like a performance issue - the hangs are for about 16 seconds or so


On 10/16/18 14:00, Black, Carey M. wrote:
Chris, (et. al.)

I have a test instance that is currently still using the HSQLDB. ( I know... I am going
to reset the env and move to a "real DB" ... soon...)

But I found that when a group is being added as a member of another group
this SQL takes a very long time to execute:

select member0_.id as id1_24_,
member0_.hibernate_version_number as hibernat2_24_,
member0_.subject_id as subject_3_24_,
member0_.subject_source as subject_4_24_,
member0_.subject_type as subject_5_24_,
member0_.context_id as context_6_24_,
member0_.subject_identifier0 as subject_7_24_,
member0_.sort_string0 as sort_str8_24_,
member0_.sort_string1 as sort_str9_24_,
member0_.sort_string2 as sort_st10_24_,
member0_.sort_string3 as sort_st11_24_,
member0_.sort_string4 as sort_st12_24_,
member0_.search_string0 as search_13_24_,
member0_.search_string1 as search_14_24_,
member0_.search_string2 as search_15_24_,
member0_.search_string3 as search_16_24_,
member0_.search_string4 as search_17_24_,
member0_.name as name18_24_,
member0_.description as descrip19_24_
from grouper_members member0_ cross join grouper_memberships_all_v
membership1_
where membership1_.owner_group_id=? and membership1_.field_id=?
and membership1_.member_id=member0_.id and
membership1_.immediate_mship_enabled='T'

Maybe this is the "performance issue" that you have seen from time to time in
the test scripts?
( "cross join" sounds.... like a bad idea on any system of any size.)

Maybe this is just a hibernate on HSQLDB issue? Maybe not?

Hope that helps.





Archive powered by MHonArc 2.6.19.

Top of Page