Skip Navigation

[Resuelto] Very slow queries

This support ticket is created hace 6 años, 4 meses. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Hoy no hay técnicos de soporte disponibles en el foro Juego de herramientas. Siéntase libre de enviar sus tiques y les daremos trámite tan pronto como estemos disponibles en línea. Gracias por su comprensión.

Sun Mon Tue Wed Thu Fri Sat
- 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Kolkata (GMT+05:30)

Etiquetado: ,

Este tema contiene 5 respuestas, tiene 3 mensajes.

Última actualización por ScottM9386 hace 6 años, 4 meses.

Asistido por: Minesh.

Autor
Mensajes
#924947

Hello,

using most recent ver.

My set-up....
Works-Tracks (one2many)
Tracks-Clients (many2many) with intermediary
works-publishers (many2many) with intermediary

I have a view to display all results, the Content Selection is from the Tracks-Clients intermediary CPT.
It queries, as a table:
Track Title, Client Title, Tracks-Clients intermediary field, Publisher Title, works-publishers intermediary field, Work taxonomy term, and a Work field.

I need to add more fields and terms to this view
BUT -
It's extremely slow!
120 rows of the table takes 20 seconds to load!

Is this normal?
If so, I'm afraid it's unusable for me.
Would a custom written MySQL query be faster?

Thank you,
Scott.

#927038

This should not be expected.

Can you export the data from Toolset > Import/Export that I need to replicate this, and as well your Database?
Then, send that to us so we can quickly deploy locally what you built.

Please inform us on what View which content is shown and is slow.

Then we can either escalate it as a BUG in case it is or help you to solve it.

#948293

Minesh
Supporter

Idiomas: Inglés (English )

Zona horaria: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

Well - I see you shared the export files as Beda suggested BUT - I do not see the issue when I try to load the problem URL you shared. I can see the page is loaded within 3-5 seconds.

After that I asked my one of colleague to check and he also shared following statistics.

 
Finish: 7.07 
DOMCONTENTLOAD: 5.64
Load 5.78

I do not see 20 seconds load time - am I missing anything here?

#948349

Hi Minesh,

This is truely bizarre.

I don't get it.
I've tried that link so many times from 3 different computers in 3 different locations and it always took up to 30 seconds to load.
I even tried it right after I got your response and it took 30 seconds. Then I tried again and it took 3-5 seconds. Then I tried in firefox (I use chrome) and it took 3-5 seconds.
Then I tried again in chrome and it took 30 seconds.
Then 2 more times in "private" browser windows, once in chrome and once in mozzilla - and it took 3-5 seconds.

I sent the link to someone else to try and see if they have any problems.

Something strange is going on.

enlace oculto

Thanks.
Scott.

#948374

Minesh
Supporter

Idiomas: Inglés (English )

Zona horaria: Asia/Kolkata (GMT+05:30)

What if you check with WPEngine and check with them if they can guide you with this.

Additionally, I also see two javascript errors on the browser's console:

JQMIGRATE: Migrate is installed, version 1.4.1
dataTables.responsive.min.js:26 Uncaught TypeError: Cannot read property 'Api' of undefined
    at dataTables.responsive.min.js:26
    at dataTables.responsive.min.js:5
    at dataTables.responsive.min.js:5
(anonymous) @ dataTables.responsive.min.js:26
(anonymous) @ dataTables.responsive.min.js:5
(anonymous) @ dataTables.responsive.min.js:5



buttons.colVis.min.js:1 Uncaught TypeError: Cannot read property 'ext' of undefined
    at buttons.colVis.min.js:1
    at buttons.colVis.min.js:1
    at buttons.colVis.min.js:1
#948681

Thank you.
I will look into it further.
Previously I also tested not using the datatables with same result.
However, it seems it's clearly NOT a Toolset issue - which is good news.
In private window it works fine. In regular browser window sometimes it's very slow (I just tested it again) and sometimes not.

Thank you!