Rick James

What is the purpose of    SELECT * from `wp_usermeta` ORDER BY `umeta_id`,`user_id`,`meta_key` LIMIT 6144 OFFSET 4Perhaps that query was truncated? Why is it walking through the entire table? Please provide...

Explain what longlists are.

My fingerprints for those IN clauses were   IN (N,N,N,N,N,N,N)  or  IN (S,S,S,S,S,S,S)where the number of N's was log2 of the number of IN values.  WP gives you 2 list sizes;...

pixelBrain -- Can you provide me with SHOW CREATE TABLE for the tables and some sample queries?  (I can probably get started faster with simply that info.) Rick Jamesemail: ***@***.***...

Thanks.  Here's a first pass: Without seeing the `CREATE TABLEs`, My index suggestions may be redundant. I assume "s" and "i" are the digests for literal "string" and "integer"? Skip...

Thanks.translation_id is UNIQUE in one table and PRIMARY in another.  That sort of means they could be merged into a single table.  Thoughts on that? As with WP, `BIGINT` is...

> Any update on optimizing wpml ? :) @ufo56 - Are you willing to test the indexes I supplied above?

Ugh! Do you happen to know the values of those 3 columns for the 770th row? I see that two are BIGINTs and one is VARCHAR(36); did any of those...

Can they provide the generated SQL? Rick Jamesemail: ***@***.*** On Tuesday, February 8, 2022, 05:53:33 AM PST, Oliver Jones ***@***.***> wrote: From a user: Would it be possible to add...

@tripflex - Please provide samples of the typical queries your plugin generates. I can promptly give you improved indexes. You can probably change the schemas quickly in your plugin (unlike...