I've been trying to figure this one out but am really struggling.
Environments
1 x Umbraco 4.5.2 with SQL Server (development area)
1 x Umbraco 4.5.2 with SQL Server (live production area)
Requirement Update Member properties and save.
Issue Dev Area: If I use C# to grab the member, update the properties and save... this takes no time at all (max logged 1.5 seconds)
Live Area: If I use C# to grab the member, update the properties and save... this takes a HUGE amount of time (max logged 23.5 seconds) !?!?
I thought I'd try a few things to eliminate what could be causing this:
Dev Umbraco to Dev SQL = 2 seconds (good)
Dev Umbraco to Live SQL = 5 seconds (good considering it has to bounce around servers)
Live Umbraco to Live SQL = 23 seconds (bad)
Live Umbraco to Dev SQL = 23 seconds (bad)
To me - that says it's a server issue and not SQL right?
So, would anyone have a clue as to what would cause Umbraco to slow down so badly on my Live environment? I will add, I have drilled down to the point where it's the actual 'Member.Save()' call that causes the 23 second delay..
I'd say it looks like an issue with the server. I've had issues before with connecting local dev instances of sites to live servers that have been slow, but that's normally when the DB is in another country. Is the database on the same server as the website, or is it on a separate box?
It looks like it may be a latency issue between the live server and the database server(s). Do you get a delay on creating content programatically, or calling other methods that make DB calls?
Member.Save() - speed issues
Hi and help!
I've been trying to figure this one out but am really struggling.
Environments
1 x Umbraco 4.5.2 with SQL Server (development area)
1 x Umbraco 4.5.2 with SQL Server (live production area)
Requirement
Update Member properties and save.
Issue
Dev Area: If I use C# to grab the member, update the properties and save... this takes no time at all (max logged 1.5 seconds)
Live Area: If I use C# to grab the member, update the properties and save... this takes a HUGE amount of time (max logged 23.5 seconds) !?!?
I thought I'd try a few things to eliminate what could be causing this:
To me - that says it's a server issue and not SQL right?
So, would anyone have a clue as to what would cause Umbraco to slow down so badly on my Live environment?
I will add, I have drilled down to the point where it's the actual 'Member.Save()' call that causes the 23 second delay..
Any help would be greatly appreciated.
I'd say it looks like an issue with the server. I've had issues before with connecting local dev instances of sites to live servers that have been slow, but that's normally when the DB is in another country. Is the database on the same server as the website, or is it on a separate box?
Hi Tim, thanks for your reply.
I have 4 servers setup for this:
Dev Umbraco is on it's own server.
Dev SQL is on it's own server.
Live Umbraco is on it's own server.
Live SQL is on it's own server.
But each relative Umbraco and SQL server are 'local' to each other.
**Update: The same delay in seconds happens if I use the backoffice 'Members' section within Umbraco. So it can't be my C# code at least!
It looks like it may be a latency issue between the live server and the database server(s). Do you get a delay on creating content programatically, or calling other methods that make DB calls?
is working on a reply...