Hi, after years on hosting solutions we would like to upgrade to a cloud solution.
Our actual architecture is as it follows: nginx - php-fpm - postgresql We are using Zend1 as a framework with doctrine 2.3.6. We customize a lot of thing so is not possibile right now to upgrade libs, but we are rewriting a lot of things and we are switching on a modular architecture with rest-api and microservices. This will take time and we would like to externalize the database and let this handle in a better way. As I said before we host and manage our solutions. We got 2 servers in replica. Postgresql is in master/slave mode. It works but it has been a bit hard to put up. We never liked to have the database where the web resides, so after a tons of search we are trying aiven.io to host our db (enterprise solution). After uploading our database (15G) and we connected from normal pgsql client we noticed the amazing speed, but connecting the web app produced very bad performance. A page that runs in less than 3 second in my local notebook runs in 45 seconds when connected to the remote database. The test has been done, obviously, in a heavy page. Are we missing something in configuration? We already configured APCu cache, and no eager fetch is envolved. -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
