New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Optimize FTS search performance #26

Closed
haulmont-git opened this Issue Apr 27, 2018 · 7 comments

Comments

@haulmont-git
Copy link

haulmont-git commented Apr 27, 2018

FtsServiceBean.makeSearchResult uses the DataManager for reloading each entity of the Lucene search result. This is done to check security constraints. A new query in a new transaction is executed for each entity. We can execute query not for the single, but for the batch of entities.


Original issue: https://youtrack.haulmont.com/issue/PL-10748

@haulmont-git haulmont-git added this to the Undefined milestone Apr 27, 2018

@rapekas rapekas removed the fts label Apr 28, 2018

@jreznot jreznot removed this from the Undefined milestone May 18, 2018

@gorbunkov gorbunkov added this to the Release 6.10 milestone Jul 30, 2018

@andreysubbotin

This comment has been minimized.

Copy link
Member

andreysubbotin commented Aug 2, 2018

  • FTS Search shows results grouped by entity class.
  • FTS Search screen uses paging buttons at the bottom of the screen like in Google. These buttons are used for navigation between pages of the results. Next page button clears previous results and shows the next page. It is disabled on the last search page.
  • "More" button has been removed from result groups. The "Next" page button is used to see more results.
@haulmont-git

This comment has been minimized.

Copy link

haulmont-git commented Sep 6, 2018

Git changesets by subbotin:

0628ff1b in release_6_10 - Optimize FTS search performance #26

@haulmont-git

This comment has been minimized.

Copy link

haulmont-git commented Sep 6, 2018

Git changesets by subbotin:

6491d74e in master - Optimize FTS search performance #26

@haulmont-git

This comment has been minimized.

Copy link

haulmont-git commented Sep 6, 2018

Git changesets by subbotin:

d600d48d in master - Optimize FTS search performance #26

@haulmont-git

This comment has been minimized.

Copy link

haulmont-git commented Sep 6, 2018

Git changesets by subbotin:

d412c7e7 in master - Optimize FTS search performance #26

@haulmont-git

This comment has been minimized.

Copy link

haulmont-git commented Sep 6, 2018

Git changesets by subbotin:

e0282d09 in master - Optimize FTS search performance #26

Run test configuration

@haulmont-git

This comment has been minimized.

Copy link

haulmont-git commented Sep 6, 2018

Git changesets by subbotin:

cfed370a in release_6_10 - Optimize FTS search performance #26

Run test configuration

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment