<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>

CC BY-SA 3.0
2017-07-27T15:30:47.607Z
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.
medoingthings
CC BY-SA 3.0
2017-07-27T15:03:04.547Z
2017-07-27T15:03:04.547Z
andrew.welch
<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>

<performance><multi-environment><workflow>
Why is Craft extremely slow when using a shared, external database?
# 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 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.  

---

