Possibly just amount of network time involved: you should at least have the DB close to your server (for less-than-10ms pings).
The roundtrip for a high amount of queries is obviously always going to be a disaster. Try attaching an SQL logger and see the query times for both environments? On 21 Oct 2017 20:10, "Gianpaolo Di Nino" <[email protected]> wrote: > 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. > -- 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.
