Recently I’ve switched my Internet provider. The new one delivers Internet trough optic fiber to the last mile and the speed should be 100MBit/s. Speed tests over a cable confirm the speed is very close to 100 MBit/s. I however noticed some lags and slowness on my laptop when using WiFi which was not expected. Speedtest.netshowed this:
The results are far away from what I would expect! Again, when attached via LAN cable – everything is fine.
For reports on my timeseries data I really needed Windowing functions like LAG(), LEAD(), ROW_NUMBER() etc. The speed and flexibility you gain using Windowing functions is incredible compared to imitating LAG() using “self-join” tricks. But these function are supported as of MySQL 8 and as of MariaDB 10.2.
For numerous of reasons I prefer to use MariaDB which is compatible drop-in replacement for MySQL.
Recently a Prestigio smartbook had to be reinstalled with latest Windows 10 1803. This laptop came with 32 bit Windows but had 64bit CPU. So I [wrongly] assumed 64-bit Windows would work. That was not the case!
I’d made 64-bit Windows 10 installation USB stick using Rufus (MBR:UEFI). But when booting I’ve received an error:
[FAIL] Could not locate '/efi/boot/bootia32.efi':  Not Found