2

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.

4

My suggestion would be to do what is outlined in 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.

| improve this answer | |
  • 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 Jul 27 '17 at 15:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.