CP seems to have slowed down more than usual yesterday and today, about 25secs to save a new place.
Network latency and bandwidth seems to be well within limits.
Server load over the past three days looks like this :
(https://s29.postimg.org/enmrqa5dv/kernel.png) (https://postimg.org/image/enmrqa5dv/)
(https://s29.postimg.org/9q97563er/sysload.png) (https://postimg.org/image/9q97563er/)
No excessive reports of DB locks in the log files ether.
Thanks. Not sure what it could be as all the other sites I use are ok. Adding new places used to be almost instantaneous before the server outage last month. There should be a few crashes in the logs for last night.
We've got a small amount of packet loss with some spikes in latency but nothing abnormal ( this is looking from the outside - so this is how its seen over the internet)
(https://s18.postimg.org/d0ykonked/pckets.png) (https://postimg.org/image/d0ykonked/)
I wonder if its worth nick doing a rebuild on the database files.
We've not had many error emails (which report failures) in the past couple of days.
I've just given it a quick \"vacuum\". Exporting all and re-importing is another option to make things a bit tighter but there's nothing obvious wrong anywhere, as Steve says.
Better now, only 10secs to save a new place.
That's still quite a bit of time...
I've just completely rebuilt it (exported it, then reimported to a new database file, then renamed). This could help.
I think we're just busy and suffering the side effects of the database architecture. The question is whether to live with it, move to a better in many ways database such as mysql (but which will be harder to manage) or to say that if I'm doing all that coding I might be better looking at a noSQL or a graph database solution and doing an entire rearchitecture. This is something I've been thinking of in other contexts as well, and I'm going to take a while to think about it.
Have things returned to normal?
New entries today take between 10secs and 15secs to complete from the [Edit place details] so not too bad. I have noticed that over the past month the map does not appear (when loading a new page) although the markers do. Refreshing the page or moving the map around works to provide a normal page. This usually happens when loading from the [New Contributions] pages in quick succession.
I've noticed some problems with the map - but that's being rendered by script running from your browser against Google's Map server.... and as the script that renders the markers is part of the same code it suggests maybe there is something not quite right with Googles Map servers.
We are having some minor latency issues at the moment (where it's spiking at over 120ms), which I'm trying to get resolved, which might be causing some issues.