Mr. Hartmann wrote on his blog

Last week, I posted a story about my interaction with a software developer who uses FireBird (FB) as a back-end for their software. The short version is that they left FB’s settings at default and were using a really, REALLY old version of FB. This caused the application to have massive (18 minute) load times and hang the entire server, with just one client connected. Bellow (in the article) are the changes I made to increase overall performance of the application and server.

Be Sociable, Share!

News via Patrick Pierson‘s blog

I found this link on reddit under /r/sysadmin. Josh Hartmann has a customer that had slowness issues with a database server. Josh contacted the developer and every time the developer’s response was to add more hardware to the problem. After some investigation he found a few issues with the developer’s setup of the server, fixed it and now his customer is happier then ever. Here is his write up, great stuff.

 

Be Sociable, Share!

In the 9th Firebird Developers Day, we collected donations to sponsor the enhancements of the Firebird wire protocol, to optimize the speed of communication in high latency networks (aka. internet). Dmitry Yemanov implemented the optimizations that were finally available for public testing with the release of the Firebird 3 Beta 1, a few days ago.

So, I decided to test the improvements. I set up a Windows remote server running FB 2.5 and 3.0 (beta1 and beta2), and used a database with a single “customers” table containing real life data (7,000 records and 61 fields). For the tests, I also created a second table with the same data, but in this one, the fields containing nulls were filled with random chars and numbers up to its size limit.

The test itself is very simple: retrieve all the fields from the first 5,000 rows from the tables, using isql (directing ther output to disk, since stdout is too “slow” and affects the results in a bad way), and check the time taken to do the fetchall. Each test was run at last twice (in sequence, filling the cache, etc), and the lowest value obtained was used for the comparison.

You can see the results below, and it is very promising! Thanks Dmitry and also Alex Peshkov (who implemented the zlib compression).

PS: There is one weird case where FB 3 was slower than FB 2.5. I already reported this do Dmitry, and he is investigating.

A full article (in portuguese) about the tests is available at FireBase. Thanks for Fernando Pimenta who “donated” the remote server for my use.

Protocol Graph

Update: Dmitry just sent me more information about the case where FB 2.5 got better performance than FB 3:

Actually, the problem is in the default batch size, not the new code itself. With all fields filled up to their max length, the protocol message size is quite similar between v2.5 and v3, the difference is less than 5%. But v3 always sends 8 packets at once while v2.5 may send 8 to 16 packets at once, depending on the message size. In your particular case, the batch size should be ~12-13 packets. This explains better performance of v2.5.

I need to find a way to adapt the new batching algorithm to better match the old one in such border cases.

Update 2 (21-jan-15): In a recent email exchange, Dmitry told me that he was able to fix the “problem” causing FB 2.5 to have better performance in that specific single case.

Be Sociable, Share!

The Firebird project has released Security Updates for the currently maintained 2.1.x and 2.5.x versions (v2.1.7 and v2.5.3 SU1). These updates fix a recently discovered security vulnerability (CORE-4630) that may be used for a remote DoS attack that could be performed by unauthorised users. We recommend Firebird users to upgrade as soon as is practical.

http://www.firebirdsql.org/en/news/security-updates-for-v2-1-and-v2-5-series-66011/

Be Sociable, Share!

Here you can check Firebird 3.0 Debian package progress

http://anonscm.debian.org/cgit/pkg-firebird/3.0.git/log/

Damyan added quite a few changes compared with version from 3 years ago

Be Sociable, Share!

News via Brent Rowland:
Rails activerecord-fb-adapter v0.9 includes a major overhaul courtesy of Ray Zane. 20x more tests now pass.
Update : now is pushed to rubygems

Be Sociable, Share!

Firebird Project announces the first Beta release of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing.

This Beta release demonstrates the features and improvements currently under development by the Firebird development team. Our users are appreciated giving it a try and providing feedback here. Apparent bugs can be reported directly to the bugtracker.

Beta releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.

Please read the Release Notes carefully before installing and testing this Beta release.
Download page:
http://www.firebirdsql.org/en/firebird-3-0-0-beta1/

Release Notes:
http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_Beta1-ReleaseNotes.pdf


Dmitry Yemanov

Be Sociable, Share!

Firebird can be installed on both Little Endian (ppc64el) and Big Endian(ppc64) versions of Power8 Linux Operating Systems

There was a recent bug in detection of ppc64el (was mis-detected as powerpc64) but now is fixed in Debian

Also if you use other distros on power8 please verify if Firebird platform is detected correctly.

Be Sociable, Share!

Only today you have ability to buy any IBSurgeon product for 50% of its regular price.
For example, IBSurgeon Enterprise Pack will cost EUR274.5 instead of EUR 549.
Upgrade to FirstAID for 50 databases – EUR 99.5 instead of EUR 199.

How to buy?

Visit our online Purchase page (http://ib-aid.com/en/purchase-ibsurgeon-firstaid-recovery/), select product, and enter the following coupon code during purchase process:
blackfriday2014

Have a good weekend!

Be Sociable, Share!

Here are some stats and badges via shields.io
SourceForge Downloads per Month:
SourceForge Downloads per Week:
SourceForge Downloads per Day:
SourceForge Downloads Total:

You can find the download stats on the sourceforge file stats area

Be Sociable, Share!

« Previous PageNext Page »

Link to us!

This Firebird & Interbase WebRing site owned by Carlos H. Cantu .
[ Previous 5 Sites | Previous | Next | Next 5 Sites | Random Site | List Sites ]