Answers.Body: <p>My suggestion would be to do what is outlined in <a href="https://nystudio107.com/blog/database-asset-syncing-between-environments-in-craft-cms" rel="noreferrer">Database &amp; Asset Syncing Between Environments in Craft CMS</a></p>
  
  <p>It's a little bit of logistical organization coupled with some scripts to do the asset/db synchronization.</p>
  
  <p>It's going to be much, much faster than working with a remote db... and safer, too.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-27T15:30:47.607Z
Answers.Text: Thanks, will dig into the article in detail. Meanwhile I gathered more information on why those delays are happening. The reason is that Craft makes 200+ requests to the database... synchronously. So syncing databases and things like that really seem to be the only solution.
Answers.UserDisplayName: medoingthings
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-27T15:03:04.547Z
Answers.LastActivityDate: 2017-07-27T15:03:04.547Z
Answers.UserDisplayName: andrew.welch
Body: <p>Every now and then I work in developer teams where we all use our local development environment to work on the code, but share the same database on a remote server (like discussed <a href="https://craftcms.stackexchange.com/questions/16380/recommended-workflow-when-developing-new-websites">here</a> etc.).</p>
  
  <p>Most of the time this will kill Crafts performance big time on our local machines. Requests take up to 30 seconds in the Control Panel and in the front-end as well. </p>
  
  <p>Does anyone else encounter the same behavior and/or has an idea how to improve that? The logs don’t explain much.</p>
  
  <pre><code>Time:   25.85331s
  (index):3505 Memory: 25,723Kb
  (index):3506 Total Queries: 287
  ...
  </code></pre>
  
  <p>The site on the remote server is snappy like you would expect it.</p>
  
Tags: <performance><multi-environment><workflow>
Title: Why is Craft extremely slow when using a shared, external database?
ThreadText: # Why is Craft extremely slow when using a shared, external database?
  
  (Asked by: username_0 on 2017-07-27)
  
  Every now and then I work in developer teams where we all use our local development environment to work on the code, but share the same database on a remote server (like discussed [here](https://craftcms.stackexchange.com/questions/16380/recommended-workflow-when-developing-new-websites) etc.).
  
  Most of the time this will kill Crafts performance big time on our local machines. Requests take up to 30 seconds in the Control Panel and in the front-end as well.
  
  Does anyone else encounter the same behavior and/or has an idea how to improve that? The logs don’t explain much.
  
  ```
  Time:   25.85331s
  (index):3505 Memory: 25,723Kb
  (index):3506 Total Queries: 287
  ...
  
  ```
  
  The site on the remote server is snappy like you would expect it.
  
  **Tags:** performance, multi-environment, workflow
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-07-27. Score: 4 | Accepted answer
  
  My suggestion would be to do what is outlined in [Database & Asset Syncing Between Environments in Craft CMS](https://nystudio107.com/blog/database-asset-syncing-between-environments-in-craft-cms)
  
  It's a little bit of logistical organization coupled with some scripts to do the asset/db synchronization.
  
  It's going to be much, much faster than working with a remote db... and safer, too.
  
  > **Comments:**
  > **username_0**: Thanks, will dig into the article in detail. Meanwhile I gathered more information on why those delays are happening. The reason is that Craft makes 200+ requests to the database... synchronously. So syncing databases and things like that really seem to be the only solution.  
  
  ---
  
  