Skip to content
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.

Sign up for GitHub

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

Jump to bottom

[FEATURE] Add Indexes for tx_solr_indexqueue_item #3772

Closed
brandung-gs opened this issue Aug 31, 2023 · 1 comment · Fixed by #3790
Closed

[FEATURE] Add Indexes for tx_solr_indexqueue_item #3772

brandung-gs opened this issue Aug 31, 2023 · 1 comment · Fixed by #3790

Comments

@brandung-gs
Copy link

We have ~80,000 entries in this table. With two new indexes we could improve the performance in the backend module "Index queue" and in the scheduler.

Quite simply, first only an index on root.

Another index on root in combination with indexing_configuration(15), which is used for the percentage display of tasks in the scheduler. Here we could improve the backend page load time by 50%.

Maybe this is something general for the extension?
@dkd-kaehm dkd-kaehm changed the title [TASK] New Indexes for tx_solr_indexqueue_item [FEATURE] Add Indexes for tx_solr_indexqueue_item Sep 11, 2023
@dkd-kaehm
Copy link
Collaborator

@brandung-gs
Thanks for this request.
Please provide a pull-request for that feature.

dkd-friedrich added a commit to dkd-friedrich/ext-solr that referenced this issue Sep 20, 2023
@dkd-friedrich
[FEATURE] Add index queue indices
801f3d1 
Adds 2 further index queue indices to reduce run-time.

Resolves: TYPO3-Solr#3772
@dkd-friedrich dkd-friedrich mentioned this issue Sep 20, 2023
Merged
dkd-friedrich added a commit to dkd-friedrich/ext-solr that referenced this issue Sep 20, 2023
@dkd-friedrich
[FEATURE] Add index queue indices
051ecc7 
Adds 2 further index queue indices to reduce run-time.

Ports: TYPO3-Solr#3790
Resolves: TYPO3-Solr#3772
@dkd-friedrich dkd-friedrich mentioned this issue Sep 20, 2023
Merged
dkd-friedrich added a commit to dkd-friedrich/ext-solr that referenced this issue Sep 20, 2023
@dkd-friedrich
[FEATURE] Add index queue indices
4519a8a 
Adds 2 further index queue indices to reduce run-time.

Ports: TYPO3-Solr#3790
Resolves: TYPO3-Solr#3772
dkd-friedrich added a commit that referenced this issue Sep 20, 2023
@dkd-friedrich
[FEATURE] Add index queue indices
df31241 
Adds 2 further index queue indices to reduce run-time.

Resolves: #3772
dkd-friedrich added a commit that referenced this issue Sep 20, 2023
@dkd-friedrich
[FEATURE] Add index queue indices
68ae447 
Adds 2 further index queue indices to reduce run-time.

Ports: #3790
Resolves: #3772
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[FEATURE] Add index queue indices dkd-friedrich/ext-solr
2 participants
@dkd-kaehm @brandung-gs