Closed MarvinKlein1508 closed 1 year ago
At the moment, this sounds more like a support question than a bug report. Please ask support questions on firebird-support.
As an aside, the file you posted is not your firebird.conf
, but your fbtrace.conf
.
I think it is a bug within the software. We had the same issue on our old server.
Thanks for the info, I updated my post above with the firebird.conf now.
I have both SATA and NVMe SSD and must say that Firebird on NVMe runs faster than on SATA SSD. So far I agree with Mark - looks like support question.
What is your OS, what brand and model NVMe?
We are using Windows Server 2019 64 Bit. The NVME is a Samsung Evo 970 Pro
Also I forgot to mention that I am talking about performance within the Firebird .NET adapter.
@MarvinKlein1508 You need to install Samsung driver for NVME to be able to get full performance. IBSurgeon has article about this.
We were struggling with a very bad Firebird performance on similar NVME model, only Samsung 980 PRO. In the end, the issue was with storage controller drivers. After finding the correct drivers (which was a big pain as there are no official drivers for this), the issue has been resolved. This is the link with the drivers that we ended up using https://winraid.level1techs.com/t/recommended-ahci-raid-and-nvme-drivers/28310
Thanks for the info.
I think this ticket should be closed as not planned.
We have a Firebird 4 database which is currently stored on a SATA-SSD. The performance is fine in this scenario. Noe we put a nvme SSD into our server and copied the database over to the nvme. The performance is now significantly worse with up to 5 times longer loading from all our queries.
We also tried to install firebird on the nvme but there is no difference in performance when doing so. We also experienced the same issue with a firebird 2.5 and 3.0 database.
Is there any magic workaround to get better performance from an NVME? All other applications are running much faster on the NVME except for Firebird. The OS is not installed on this nvme, it is a separate drive.
This is our firebird.conf