Re: [firebird-support] Slow Firebird performance in Azure with durable data disks (e.g., Premium Storage)

2016-08-30 Thread Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support]
Hi Antti, Try to lock database with nbackup and check the peformance with locked database - in this case all writes will go to delta file sequentially. If your assumption is true and Premium Storage does not work good with random writes, you will see less decrease of performance. Also, there

[firebird-support] Slow Firebird performance in Azure with durable data disks (e.g., Premium Storage)

2016-08-30 Thread Antti Nivala antti.niv...@m-files.com [firebird-support]
Hi, We've experimented with the performance of Firebird in virtual machines in Microsoft's Azure cloud. With Azure VMs, any durable data needs to be placed in "data disks", and essentially that means network-connected storage that is inherently slower than e.g. local SSD disks. When testing