Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Deleting pages takes a long time

Description

In large databases, (for me 2.8 million records in ResourcePermission), deleting a page takes a long time. This is the query that takes a long time (~6 seconds):

SELECT * FROM ResourcePermission WHERE (ResourcePermission.companyId = 1) AND (ResourcePermission.primKey LIKE '326317_LAYOUT%');

Activity

Show:

Michael SaechangJanuary 19, 2012 at 6:24 PM
Edited

Committed on:
6.0.x GIT ID: fccd8ba222b1ad1cea4976f56f7f92fed14a38f8.
6.1.x GIT ID: 253ab6daf4a146a738c4f1015fe3a0135a2b2234.
6.2.x GIT ID: ac0e31a6f147ad73f8e5089a6abec27bb4438bdd.

Amos FongJanuary 17, 2012 at 7:33 PM

thanks!

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Branch Version/s

6.1.x
6.0.x

Backported to Branch

Committed

Caused by

Other bug fix

Git Pull Request

Components

Fix versions

Affects versions

Priority

Zendesk Support

Created January 9, 2012 at 10:59 PM
Updated June 24, 2023 at 3:43 PM
Resolved March 12, 2012 at 1:40 PM

Flag notifications