Details

    • Branch Version/s:
      6.0.x
    • Backported to Branch:
      Committed

      Activity

      Hide
      cpuman01 mahdi tilab (Inactive) added a comment -

      I applied all modified files in issue LPS-13979 but asset publisher is slow too

      Show
      cpuman01 mahdi tilab (Inactive) added a comment - I applied all modified files in issue LPS-13979 but asset publisher is slow too
      Hide
      felipe.sere Felipe Sere (Inactive) added a comment -

      I am having the same issue. We had to disable the Asset Publisher on our Wiki site because it slowed everything down to a crawl.

      How can I assist in fixing this issue ASAP?

      Show
      felipe.sere Felipe Sere (Inactive) added a comment - I am having the same issue. We had to disable the Asset Publisher on our Wiki site because it slowed everything down to a crawl. How can I assist in fixing this issue ASAP?
      Hide
      sesq Piotr Filipowicz (Inactive) added a comment -

      I have the same problem.
      On my production portal there is 30 000 articles and I have 20 users. If all users send requests some pages render very slow. IMHO there is a big query, which get count to asset publisher portlet (dynamic mode). AssetEntryFinderImpl and countEntries method kills my portal.

      Time of execute this query is about 20s. What can I do with it?

      Show
      sesq Piotr Filipowicz (Inactive) added a comment - I have the same problem. On my production portal there is 30 000 articles and I have 20 users. If all users send requests some pages render very slow. IMHO there is a big query, which get count to asset publisher portlet (dynamic mode). AssetEntryFinderImpl and countEntries method kills my portal. Time of execute this query is about 20s. What can I do with it?
      Hide
      cpuman01 mahdi tilab (Inactive) added a comment -

      I make some changes in AssetEntryFinderImpl.

      I remove 'DISTINCT' keyword and remove ORDER BY title. now my performance is better but not qualified

      Regards

      Show
      cpuman01 mahdi tilab (Inactive) added a comment - I make some changes in AssetEntryFinderImpl. I remove 'DISTINCT' keyword and remove ORDER BY title. now my performance is better but not qualified Regards
      Hide
      jorge.ferrer Jorge Ferrer added a comment -

      I've changed the issue type to improvement and changed the priority to major.

      For those that have tried applying some of the suggested improvements, it would be appreciated if you could contribute a patch and specify the tests that have been done to ensure that all the Asset Publisher features are still working as expected.

      Show
      jorge.ferrer Jorge Ferrer added a comment - I've changed the issue type to improvement and changed the priority to major. For those that have tried applying some of the suggested improvements, it would be appreciated if you could contribute a patch and specify the tests that have been done to ensure that all the Asset Publisher features are still working as expected.
      Hide
      brian.chan Brian Chan added a comment -

      Fix is to create a few indexes.

      create index IX_75D42FF9 on AssetEntry (expirationDate);
      create index IX_2E4E3885 on AssetEntry (publishDate);
      create index IX_9029E15A on AssetEntry (visible);

      Show
      brian.chan Brian Chan added a comment - Fix is to create a few indexes. create index IX_75D42FF9 on AssetEntry (expirationDate); create index IX_2E4E3885 on AssetEntry (publishDate); create index IX_9029E15A on AssetEntry (visible);
      Hide
      vicki.tsang Vicki Tsang (Inactive) added a comment -

      This is being bulk closed in preparation for the new workflow.

      Show
      vicki.tsang Vicki Tsang (Inactive) added a comment - This is being bulk closed in preparation for the new workflow.
      Hide
      cpuman01 mahdi tilab (Inactive) added a comment -

      Why AssetEntry finder queries not use hql?

      I think AssetEntry finder queries not cached with ehcache. is it correct? is there any way to make sure this query hits level-2 cache?

      thanks

      Show
      cpuman01 mahdi tilab (Inactive) added a comment - Why AssetEntry finder queries not use hql? I think AssetEntry finder queries not cached with ehcache. is it correct? is there any way to make sure this query hits level-2 cache? thanks

        People

        • Votes:
          5 Vote for this issue
          Watchers:
          7 Start watching this issue

          Dates

          • Created:
            Updated:
            Resolved:
            Days since last comment:
            5 years, 21 weeks, 6 days ago

            Development

              Subcomponents