[MODFQMMGR-45] Query builder - Slow performance of test queries executed against Items entity type Created: 12/Oct/23  Updated: 23/Oct/23  Resolved: 23/Oct/23

Status: Closed
Project: mod-fqm-manager
Components: None
Affects versions: None
Fix versions: 1.0.0

Type: Story Priority: P2
Reporter: Punnoose Kutty Jacob Pullolickal Assignee: Matt Weaver
Resolution: Done Votes: 0
Labels: back-end
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Sprint: Corsair Sprint 176
Story Points: 2
Development Team: Corsair
Release: Poppy (R2 2023)
RCA Group: Implementation coding issue

 Description   

Purpose/Overview:

Purpose of this story is to fix slow performance of queries executed against "Items" entity type.

 

Examples of slow queries:

  1. Instance title = Ireland and the Irish:Cathleen ni Houlihan is alive and well. – Takes 7 minutes to execute
  2. Instance title Starts with Ireland – Takes 7 minutes to execute
  3. instance ID = 0918f889-26bc-4416-bece-9d076e11bdef  -- this is much faster than the previous 2

 

Proposed solution:

Create a smaller view that just join "item", "holdingrecords" and "instance" tables.

 

 



 Comments   
Comment by Matt Weaver [ 18/Oct/23 ]

With the smaller view, we get faster results in some cases. Note: because we convert text fields to lower case when doing text operators, we can't take full advantage of the indexes involved yet, but that will requite some extra work that is out of scope of this ticket

Generated at Thu Feb 08 22:32:12 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.