[FOLIO-1918] Resolve Users search slowness due to search query Created: 27/Mar/19  Updated: 03/Jun/20  Resolved: 29/Mar/19

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: Story Priority: P2
Reporter: Eric Valuk Assignee: Hongwei Ji
Resolution: Duplicate Votes: 0
Labels: platform-backlog
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Duplicate
duplicates MODUSERS-106 add index for searching by "username" Closed
Relates
relates to FOLIO-1903 SPIKE: investigate which APIs contrib... Closed
Sprint: Core: Platform - Sprint 60
Story Points: 0
Development Team: Core: Platform

 Description   

https://okapi-snd-eu-central-1.folio.ebsco.com/users?limit=30&query=(((username="eric*" or personal.firstName="eric*" or personal.lastName="eric*" or personal.email="eric*" or barcode="eric*" or id="eric*" or externalSystemId="eric*")) and active="true") sortby personal.lastName personal.firstName

This call takes 3.5 seconds(or more in some cases) on bugfest environment.

I have a couple of questions related to this:
Is it possible to optimize this call via sql?
Is it a good idea to do so?
Should we investigate other options for optimization?



 Comments   
Comment by Eric Valuk [ 27/Mar/19 ]

other related queries:

https://okapi-snd-eu-central-1.folio.ebsco.com/users?limit=30&query=((username="eric*" or personal.firstName="eric*" or personal.lastName="eric*" or personal.email="eric*" or barcode="eric*" or id="eric*" or externalSystemId="eric*")) sortby personal.lastName personal.firstName

Generated at Thu Feb 08 23:16:51 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.