# \[Solved\] Query to database takes too long

**URL:** <https://discourse.cakephp.org/t/solved-query-to-database-takes-too-long/3999>\
**Category:** Performance\
**Created:** [March 5, 2018, 6:19pm UTC](https://discourse.cakephp.org/t/solved-query-to-database-takes-too-long/3999 "2018-03-05T18:19:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vgz](https://avatars.discourse-cdn.com/v4/letter/v/258eb7/32.png) [@Vgz](https://discourse.cakephp.org/u/Vgz)\
**Post date:** [March 5, 2018, 6:19pm UTC](https://discourse.cakephp.org/t/solved-query-to-database-takes-too-long/3999/1 "2018-03-05T18:19:05Z")

</div>

Greetings.

Probably the performance problem is not related with CakePHP. I have a remotely database inside my LAN. ( 1Gbps) it takes about 10 seconds to connect to the database and execute any query. The webserver is my own host, and the database is a Linux virtualized.

I have the skype-resolve-name already configured in my.cnf.

Any advice ?.

Peak Memory Use: 8.21 MB  
Message Memory Use  
Controller initialization 4.37 MB  
Controller action start 4.37 MB  
View Render start 6.31 MB  
Controller shutdown 7.27 MB  
Timers  
Total Request Time: 10,140 ms  
Event Time in ms Timeline  
Core Processing (Derived from $\_SERVER[“REQUEST\_TIME”]) 50.21   
Cache.read translations.debug\_kit.en\_US 1.44   
Event: Controller.initialize 0.01   
Event: Controller.startup 0.06   
Controller action 10,046.22   
Cache.read default\_users 0.26   
Cache.write default\_users 3.02   
Event: Controller.beforeRender 0.06   
View Render start 15.34   
Event: View.beforeRender 0.00   
Render E:\developer\CakePHP\inventory\src\Template\Users\index.ctp 11.75   
Cache.read translations.default.en\_US 0.27   
Event: View.afterRender 0.00   
Event: View.beforeLayout 0.00   
Render E:\developer\CakePHP\inventory\src\Template\Layout\default.ctp 0.86   
Event: View.afterLayout 0.00   
Event: Controller.shutdown 15.79   
Cache.read debug\_kit\_requests 0.25   
Cache.read translations.cake.en\_US 0.26   
Cache.read debug\_kit\_panels 0.25

Thanks.

---

<div class="post-metadata">

**Author:** ![Vgz](https://avatars.discourse-cdn.com/v4/letter/v/258eb7/32.png) [@Vgz](https://discourse.cakephp.org/u/Vgz)\
**Post date:** [March 5, 2018, 7:57pm UTC](https://discourse.cakephp.org/t/solved-query-to-database-takes-too-long/3999/2 "2018-03-05T19:57:28Z")

</div>

I’ts solved.

Was added in the wrong line, [mysql] not [mysqld]