Subject Re: [firebird-support] Scaling Firebird - Azure
Author Alexey Kovyazin (ak)
Post date 2019-10-09T11:51:40Z
Hello,

Azure simply does not deliver what it promises - simple test www.ib-aid.com/dbtest gives results for Azure premium ssd in the lowest 25%, simple CrystalDiskMarks shows awful results too. 
Your server is yours, but Azure promises Enterprise grade performance, without worries abour RAID, ssd, etc - but what we get is far from it, as well as from money paid for it. On other side, Google Cloud shows reasonable results in these tests, so why pay for the worst option.
Amazon EC2 with ssd also looks better than Azure in terms of performance, but seems to be much more expensive than Digital Ocean, Hetzner and even Google Cloud. 



Regards, 
Alexey Kovyazin 
IBSurgeon 

ср, 9 окт. 2019 г., 10:49 'Louis van Alphen' louis@... [firebird-support] <firebird-support@yahoogroups.com>:
 

I think it is unfair to say Azure sucks. I have had huge performance issues with FB on a normal server with server grade SSDs. My desktop PC with spindle HDD outperforms it by an order of magnitude. To date it has not been resolved but I suspect it has to do with the RAID controller. The same server is very fast with MSSQL.

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups..com]
Sent: Wednesday, 09 October, 2019 08:17
To: Nagy Szilveszter nagy_szilveszter@... [firebird-support] <firebird-support@yahoogroups.com>
Subject: Re: [firebird-support] Scaling Firebird - Azure

Hello,

In short words, Azure sucks, its so called Premium SSD is worse than the cheapest consumer grade ssd.

Try Google Cloud or Amazon, or Hetzner.

Regards,

Alexey Kovyazin

IBSurgeon

пн, 7 окт. 2019 г., 0:20 Rune Horneland rune.horneland@... <mailto:rune.horneland@...> [firebird-support] <firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> >:

Hi,

We are running Firebird 2 in an Azure VM. It can only take so much in terms of concurrent connections.

What top-level advice would you give to scale this?

We are connecting to it from a .NET core Middleware using Azure VMs.

The architecture of the middleware is quite monolithic. We are considering rewriting it with Microservices and Azure functions or similar architecure, but are unsure how we could scale the Firebird DB or connections itself.

Multiple casehandlers in our company use it via a Delphi-based Windows application at the other end, with a vendor maintaining the Firebird DB and Windows app development, so we are locked into using Firebird.

RUNE HORNELAND
CTO

[Non-text portions of this message have been removed]