Details

      Description

      Our persistence classes have a few PrevAndNext find methods. They are using Hibernate's scroll query, hibernate actually gets all the results that meet the where cause, then scroll it locally. For some huge result set, this can cause very heavy network traffic.

      In our Blogs benchmark test, the findByGroupId PrevAndNext method causes a 50MB/s traffic from database under a heavy load.

      This fix uses two selects to fetch the previous and next result individually, so it saves the network traffic significantly(From 50MB/s to 3MB/s).

      It also saves a lot of gc, since most results from database will become garbage immediately.

        Attachments

          Activity

            People

            • Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              shuyang.zhou Shuyang Zhou
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 51 weeks, 3 days ago

                Packages

                Version Package
                6.0.1 RC
                6.0.2 RC