I have a website built on Umbraco that is using a huge database of nodes, images, and members. (around 190K right now and growing)
Because of this the queries used by load balanced instances to catch up with changes in the database are taking longer and longer. So much so that we are getting timeouts.
These timeouts are not in the database connection or queries, but for some reason they are request timeouts because the sync operation happens during a request. Why is this? Why not run the sync operations in the background? Why wait for a request and why perform the sync during the request, causing it to run slower than other requests?
And finally, is there a way to change this behavior or do I have to change Umbraco code?
Why sync the index in the context of a request?
Hi,
I have a website built on Umbraco that is using a huge database of nodes, images, and members. (around 190K right now and growing)
Because of this the queries used by load balanced instances to catch up with changes in the database are taking longer and longer. So much so that we are getting timeouts.
These timeouts are not in the database connection or queries, but for some reason they are request timeouts because the sync operation happens during a request. Why is this? Why not run the sync operations in the background? Why wait for a request and why perform the sync during the request, causing it to run slower than other requests?
And finally, is there a way to change this behavior or do I have to change Umbraco code?
Thanks,
Paul.
Hi Paul,
What Umbraco version are you using?
Thanks,
Alex
Hi Alex,
I am on version 7.4.3.
Thanks,
Paul.
is working on a reply...