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.

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

Indexes for form and feuser in the tx_powermail_domain_model_mail table #1017

Closed
tobiasschaeferptb opened this issue Apr 24, 2024 · 1 comment
Labels

Comments

@tobiasschaeferptb
Copy link

Hello,

we had performance issues with an installation with thousands of entries in tx_powermail_domain_model_mail table.
The problem occured in the backend on pages with powermail plugins and in the frontend on pages with the powermail frontend plugin.
We could solve the issue by adding 2 indexes for the columns form and feuser in the tx_powermail_domain_model_mail table.
ext_tables.sql, line 207, change from:
KEY language (l10n_parent,sys_language_uid)
to

KEY language (l10n_parent,sys_language_uid),
KEY form (form),
KEY feuser (feuser)

Would it be possible to add these two indexes?

Best regards,
Tobias Schaefer

@mschwemer mschwemer added the v12 label May 21, 2024
@mschwemer
Copy link
Collaborator

Included in 12.3.4

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants