Yes it improve sync writes. But this is not write cache. This is separate log device. Zfs does not have write cache. Cache it something when you firstly write Next sometimes read from cache. ZFS SLOG readed only when recovering after Power outage! Thats why this is not write cache!
Of course more productive will be move full db on ssd. And we finally waited for this.