[INP-1769] Truncate search result table instead of dropping it - In-Portal Issue Tracker

XML

Word

Printable

Details

Type: Task
Status: Resolved
Priority: Minor
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 5.2.2-B3
Component/s: Front End
Labels:
None

Change Log Group:
Changed
Change Log Message:
Search table on Front-End is now created in memory and truncated instead of dropping.
Story Points:
1
Copy Issue Key:
Patch Instructions:
Patches must be submitted through Phabricator.
- To submit patch via Command Line use Patches Workflow (via Arcanist) tutorial
- To submit patch via Web Interface use Patches Workflow (via Web Interface) tutorial

Description

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
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

Attachments

Issue Links

implemented in

[Diffusion] rINP16655 Fixes INP-1769 - Truncate search result table instead of dropping it

D366 INP-1769 - Truncate search result table instead of dropping it

mentioned in: Page Loading...

Activity

People

Assignee:

Alex

Reporter:

Alex

Developer:

Alex

Reviewer:

Erik Snarski [Intechnic]

Votes:

0 Vote for this issue

Watchers:

2 Start watching this issue

Dates

Created:

30/May/19 7:48 AM

Updated:

1 hour ago

Resolved:

04/Jan/21 2:48 AM

Time Tracking

Estimated:

Not Specified

Remaining:

0h

Logged:

2h