Truncate search result table instead of dropping it

Components

Labels

Description

  1. in the "OnSimpleSearch" events:

    • use "MEMORY" engine, when creating temp search table (improves speed)

    • instead of dropping temp search table clean it using "TRUNCATE TABLE" database query

  2. in the "\kSearchHelper::ensureEmptySearchTable" method:

    • create temp search table in memory and only, when it's missing

    • clean temp search table using "TRUNCATE TABLE" database query

Context Information

None

Additional information (do not use)

None

Activity

Alex January 4, 2021 at 10:48 AM

alex closed D366: https://in-portal.atlassian.net/browse/INP-1769#icft=INP-1769 - Truncate search result table instead of dropping it.
alex updated the diff for D366: https://in-portal.atlassian.net/browse/INP-1769#icft=INP-1769 - Truncate search result table instead of dropping it.

Alex January 4, 2021 at 8:48 AM

alex added "INP-1769" JIRA issue(s) to rINP16655: Fixes https://in-portal.atlassian.net/browse/INP-1769#icft=INP-1769 - Truncate search result table instead of dropping it.

Alex January 4, 2021 at 8:48 AM

alex committed rINP16655: Fixes https://in-portal.atlassian.net/browse/INP-1769#icft=INP-1769 - Truncate search result table instead of dropping it.

Fixes https://in-portal.atlassian.net/browse/INP-1769#icft=INP-1769 - Truncate search result table instead of dropping it

Differential Revision: http://qa.in-portal.org/D366

Alex January 4, 2021 at 8:48 AM

alex closed D366: https://in-portal.atlassian.net/browse/INP-1769#icft=INP-1769 - Truncate search result table instead of dropping it.
alex updated the diff for D366: https://in-portal.atlassian.net/browse/INP-1769#icft=INP-1769 - Truncate search result table instead of dropping it.

[API] Administrator January 4, 2021 at 8:48 AM

User committed a fix to 5.2.x. Commit Message:

Fixes https://in-portal.atlassian.net/browse/INP-1769#icft=INP-1769 - Truncate search result table instead of dropping it

Differential Revision: http://qa.in-portal.org/D366

Fixed

Details

Priority

Assignee

Reporter

Developer

Reviewer

Change Log Group

Changed

Change Log Message

Patch Instructions

Patches must be submitted through Phabricator.

Time tracking

2h logged

Story Points

Fix versions

Created May 30, 2019 at 12:48 PM
Updated December 29, 2024 at 8:49 PM
Resolved January 4, 2021 at 8:48 AM

Flag notifications