The Data warehouse lives for another winter.
Last month I tried to move the database to the Azure cloud. We knew it would probably not work out well, the latency turned out to be a bit over three times longer with the database in the cloud, a bit better than expected, but still to much.
The company is very eager to move the Data Warehouse to the cloud, and I agreed to help them out. It is a lot of work since I have to upgrade software and opsys to modern versions, eg PHP 5 to at least 7.4. Last upgrade of the data warehouse was done 2012. I will most likely work on and off with this project most part of the autumn, eventually into the winter. Right now I have a problem with a closure in PHP 7.4 that drives me nuts. I spent about three days with this and I still do not understand the problem. I think I need to take a step back and really focus on tracing the bug.
