This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Looker Studio is very slow with MySQL

Posted on 09-09-2024 05:10 AM
davidecesarano
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

I notice thath Looker Studio is very slow while loading data from MySQL database for report generation. I tried to reboot my server and the MySQL engine but this issue still persists. Is this a Looker issue or can I try to resolve somehow?

Edit 16/09/2024. Problem is solved

2 3 300
Topic Labels
3 REPLIES 3

Posted on --/--/---- --:-- AM
abobasher
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

Same issue here!

0 Likes

Posted on --/--/---- --:-- AM
francocestari
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hemos embebido Looker en nuestra plataforma, pero hemos observado que los informes cargan muy lentamente. Aunque no soy programador y mi rol se centra en el diseño de los tableros, un experto en la materia me indicó que cada "recuadro del tablero" realiza consultas por separado a la base de datos, lo que podría estar contribuyendo a la lentitud de la herramienta, entre otras posibles razones.

¿Podrían considerar optimizar este aspecto para mejorar el rendimiento? Agradecería mucho cualquier sugerencia o solución que puedan ofrecer.

¡Muchas gracias!



0 Likes

Posted on --/--/---- --:-- AM
davidecesarano
Bronze 2
Bronze 2
In response to francocestari
Reply posted on --/--/---- --:-- AM

Hi. The problem is solved.

It's true, each component of the dashboard represents a query. To improve performance it is important to set the indexes (index key) on the tables correctly and have tables with not too many records.

0 Likes