QinisoM's Replies | ww.wp.xz.cn

Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)

Forum: Plugins
In reply to: [Rank Math SEO – AI SEO Tools to Dominate SEO Rankings] Query running too long

Thread Starter QinisoM
(@qinisom)

1 month, 1 week ago

Hi Jeremy,

Thank you for for your response, I will action the above.

Kind regards,

Qiniso

Forum: Plugins
In reply to: [TranslatePress - Translate Multilingual sites with AI Translation] Database Optimizer silently failing with a status 504
Thread Starter QinisoM
(@qinisom)

1 month, 2 weeks ago
Hi Anca, and thank you for the speedy response.

I would also like to point out that the non-paginated version of the above query
```
SELECT
  tt.id, CASE WHEN ot.original is NULL THEN tt.original ELSE NULL END as tt_original,
  tt.translated,
  tt.domain AS tt_domain,
  tt.plural_form,
  tt.original_id AS tt_original_id,
  ot.original,
  ot.domain,
  ot.context
FROM wp_trp_gettext_en_us AS tt
LEFT JOIN wp_trp_gettext_original_strings AS ot ON tt.original_id = ot.id
```
can return a very large results set, I would suggest that this be removed and only the paginated version is used.

Kind regards.
- This reply was modified 1 month, 2 weeks ago by QinisoM.
Forum: Plugins
In reply to: [TranslatePress - Translate Multilingual sites with AI Translation] Database Updater from CLI

Thread Starter QinisoM
(@qinisom)

3 months, 2 weeks ago

Hello,

Thanks for the prompt response. One last qustion:

Is there any feature planned in the near to add the DB operations as commands?

Kind regards.

Forum: Plugins
In reply to: [TranslatePress - Translate Multilingual sites with AI Translation] Too many DB operstions
Thread Starter QinisoM
(@qinisom)

10 months ago
Just an update, I found one a potential issue, the query is running repetively against the DB:
```
SELECT
  tt.id,
  CASE WHEN ot.original is NULL THEN tt.original ELSE NULL END as tt_original,
  tt.translated,
  tt.domain AS tt_domain,
  tt.plural_form,
  tt.original_id AS tt_original_id,
  ot.original,
  ot.domain, ot.context
FROM wp_trp_gettext_en_ AS tt
LEFT JOIN wp_trp_gettext_original_strings AS ot ON tt.original_id = ot.id
```
Additionally it returns a very large result set without pagination, also because of no caching it runs repetitvely which causes the DB to slow down.

Viewing 4 replies - 1 through 4 (of 4 total)