Are there any tricks I'm missing on how to speed up local development when running a remote DB. Its taking a while to come back with responses/saves/etc. Wonder if there is anything I can tickle, switch off, hidden settings etc which might speed it up a bit.
I've seen this behaviour in three different projects now. My guess is that due to the large number of queries that Umbraco makes and the packets being small, that the network stack needs to add a lot of excess (routing and header) data and is therefore taking a long time. By the way, I am no network/database specialist by far.
Unlike the public website, which makes few db calls, working in the back office of umbraco makes a lot of db calls. Thus, you can speed that up with a better connection to the remote db, a faster db server, or (mostly likely for you), add some indexes to the umbraco tables to speed up the performance of the database calls themselves.
Numerous people have suggested indexes so just look for that on the forum or via google.
Local instance using remote DB is sloooowwww
Are there any tricks I'm missing on how to speed up local development when running a remote DB. Its taking a while to come back with responses/saves/etc. Wonder if there is anything I can tickle, switch off, hidden settings etc which might speed it up a bit.
Cheers
Pete
Sorry mate, no solution that I know of.
I've seen this behaviour in three different projects now. My guess is that due to the large number of queries that Umbraco makes and the packets being small, that the network stack needs to add a lot of excess (routing and header) data and is therefore taking a long time. By the way, I am no network/database specialist by far.
Unlike the public website, which makes few db calls, working in the back office of umbraco makes a lot of db calls. Thus, you can speed that up with a better connection to the remote db, a faster db server, or (mostly likely for you), add some indexes to the umbraco tables to speed up the performance of the database calls themselves.
Numerous people have suggested indexes so just look for that on the forum or via google.
Let us know how you get on.
cheers,
doug.
Heard rumors of FamFam icons/many icons slowing down the back end, not seen this myself.
Rich
On 4.5 I thought they had sorted out the indexes on the DB? Will take a look though :)
Thanks for all the tips so far will let you know how I get on, feel free to keep them coming though!
Pete
Hi Peter,
I've seen issues like this before and am inclined to agree with Sebastiaan with regard to the increased network traffic.
Would be very interested to know if there are any network tweeks that could help with the large number of DB queries.
I haven't tried a remote DB with 4.52, I know it has additional foreign key constrains, but weren't additional indexes also added ?
Cheers,
Hendy
is working on a reply...