tag:blogger.com,1999:blog-91800903107442492192024-03-06T03:30:52.017+03:00IBDeveloperInterBase, Firebird and other interestingDmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.comBlogger53125tag:blogger.com,1999:blog-9180090310744249219.post-34719374404607145782018-11-26T15:47:00.004+03:002018-11-26T15:47:52.330+03:00Firebird Performance Tour
Firebird Performance Tour 2019 will take place in Moscow (November 29,
2018), Prague (December 4, 2018) and Bad Sassendorf, Germany (December
6, 2018).
Firebird Performance Tour will be devoted to the complex parts of SQL queries optimizations and their monitoring:
New features in Firebird 4 — Dmitry Yemanov, Firebird core developer
Explained SQL plans in Firebird 3 and 4 —&Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-73299879698071598712018-09-10T21:23:00.001+03:002018-09-10T21:23:28.543+03:00gbak -b -e. Compress or not to compress.
Normal backup (gbak -b) by default compresses data. What the compression is, I don't know, don't care, maybe will ask developers about it.
But, gbak have -e option, which turns compression off.
So, I decided to check how it will affect backup, and is there any reason to use it.
I took TPC-R database, 30 gigabytes size, Firebird 3.0.3, and made backup several times to another physical disk (to Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-52584560459608760852016-12-07T15:19:00.001+03:002016-12-07T15:19:20.325+03:00Unexpected feature
I have a task to experiment with 2 instances of InterBase XE7 at the same computer.
Install
went OK over existing instance gds_db. Don't forget to specify "Multi
instance feature" = YES and new port name and number at the second
dialog of installer.
Well, first of all, after running 2
instances of InterBase XE7, one at gds_db/3050, another at gds_db/3100,
I decided to check do they ever Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-27379822008333139142016-09-02T12:43:00.004+03:002016-09-02T12:43:58.595+03:00Incompatible Compatibility
As you know (maybe), InterBase XE7 have support of previous ODS (database format) of InterBase 2009 (ODS 13) and InterBase XE/XE3 (ODS 15).
This, I think, was supposed to help moving to XE7, starting to use XE7 with old databases, and "if something goes wrong" to have an ability to return to 2009 or XE/XE3.
But...
InterBase XE7, when opens database in ODS 13.1 format (InterBase 2009) upgrades Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-34931064210711220632016-06-07T20:21:00.000+03:002016-06-09T02:37:46.853+03:00Mess of gbak options
I see lot of places where gbak options (Firebird, InterBase) specified randomly.
Examples:
gbak -c -r
what do you mean? -c or -r? Documentation specifies -c | -r. Symbol "|" is OR, not AND. Moreover, -r is not restore, it's REPLACE!
Thanks god, Firebird 1.5 and higher disabled -r option, because it allow to drop original database file without warning. Now you must specify -rep or -r o. Anyway, Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-38551961946267007032016-04-23T18:21:00.001+03:002016-04-23T18:21:55.593+03:00Delimiter hell
You know, that each computer can have different regional settings. Moreover, some users change this settings to their preferences.
For example, if I like '.' as decimal separator, I can change it, if by default it is ','.
But, we are speaking here about Firebird and InterBase, right? Yes. There is a tool, GSTAT, used to get statistics from DB. It uses fixed decimal separator, '.'. So, if you Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-12853230246543123792012-10-10T23:15:00.000+04:002012-10-10T23:15:21.629+04:00Don't miss Firebird Conference!
Only 15 days left before Firebird Conference, Luxembourg, 26-27 October.
Unique chance to handshake Firebird developer team, drink beer/wine during evening gathering, and, of course, to learn lot of interesting things about Firebird and application development!
http://firebirdsql.org/en/firebird-conference-2012/
Read the topics list, speaker names, and join us!
Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-12880514714275824272011-09-06T15:14:00.000+04:002011-09-06T15:14:27.719+04:00Operating system on RAIDWe deal with the hardware by lot of different cases - when someone ask us what to buy for the new server, how to improve existing hadware, and, of course, when database becomes corrupted.
Many hadware vendors (as we see) sell servers with ready to use RAID (1, 5 or 10), with operating system installed on that raid. Also these hardware vendors think that it is cool that customer will place Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-77417811752659666142011-03-23T10:54:00.002+03:002011-03-23T11:44:40.619+03:00no_garbage_collectYou do not know what is that? Well, InterBase and Firebird allow specifying connection parameter that will disable garbage collection by statements in this connection.
This is the same as the option -g for gbak. And, of course, all other connections without this parameter will continue to try collecting garbage in the database, if any.
This connection option mostly is not known, because standardDmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-75348729158264217602009-10-29T01:37:00.003+03:002009-10-29T02:02:51.568+03:00Are you ready? Yes, I am.Alexey posted interesting info about sudden computer failure. Since I'm working with computers from 1987, I wan to share my experience too.3 years ago my computer won't turn on. Possible causes could be - processor, motherboard or power unit. After some thinking I choosed to buy new power unit, and I was right - motherboard and processor were alive. I was lucky not buying new motherboard, righ?Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-31988325736903768702009-09-26T03:12:00.002+04:002009-09-26T03:30:15.167+04:00Tips'nTricks using FBScannerYes, sometimes I use FBScanner too. :-)My system is complex, because I have huge number of Firebird, InterBase and Yaffil versions. While Yaffil does not interfere with Firebird and InterBase, I need to run periodically Firebird 1.0, 1.5, 2.0, 2.1, 2.5 and InterBase 6.x, 7.0, 7.1, 7.5, 2007 and 2009. I do this by removing services records with "instsvc remove" after installation, because I don't Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-47742707510066149832009-09-25T15:34:00.002+04:002009-09-25T15:44:14.917+04:00NostalgiaRemember our IBDeveloper Magazine, no? It was (and is) at the website www.ibdeveloper.com, but some time ago it was hacked, so, your browser may tell you that you should not open this link.Anyway, we started to place interesting presentations about Firebird and InterBase on Scribd, and now decided to put there our IBDeveloper Magazine, all 4 issues. And, we found old lovely InterCom magazine Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-71819103984951622432009-09-17T09:58:00.002+04:002009-09-17T10:29:09.779+04:0064 bit Delphi. Who needs it?I'm watching not only the InterBase and Firebird newsgrops and forums, but the Delphi also.And I know that at least lot of russian Delphi programmers complaining about still non-existing support of 64 bit Windows in Delphi.Today at DelphiFeeds.com I saw the post "64 bit tommorow – Wh/if you’ll have more than 4GB “today”?", and want to share my opinion on this. Also I wish you to vote at that Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com5tag:blogger.com,1999:blog-9180090310744249219.post-3341490906564250102009-08-24T09:58:00.001+04:002009-08-24T09:59:30.170+04:00Firebird - 1 terabyte databaseWe made 1 terabyte database test with Firebird 2.1. Read more. Questions?Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com3tag:blogger.com,1999:blog-9180090310744249219.post-20771792767635693312009-06-26T10:55:00.003+04:002009-06-26T11:42:44.933+04:00local protocol and multi-core processorsWe found strange behavior of local protocol connection of the Firebird SuperServer 1.5 and Windows. Tests were made on AMD 2-core processor computer with command line backup likegbak -b -g db.fdb db.fbkWhen gbak is not "attached" to cores (uses all), or "attached" to another processor core where the Firebird SuperServer runs (for example, fbserver. exe at core 0, and gbak.exe at core 1), gbak Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com2tag:blogger.com,1999:blog-9180090310744249219.post-42111349441709620162009-06-17T10:02:00.002+04:002009-06-17T10:22:30.056+04:00What is sort 2Someone may make wrong conclusion from my previous post about sorting that "sorting ... mostly does writes". But, yes, I was speaking only about temporary sort files, and the sorting process itself. The whole picture of the query with PLAN SORT is the followingserver (Firebird, InterBase) reads portions of the data from the query, does sorting of this block and writes it to the temporary file. SoDmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-67360037062625703992009-06-04T18:19:00.003+04:002009-06-04T19:12:58.690+04:00What is sort?Inspired by discussion about sorting (PLAN SORT), did some simple tests. Right now I do not have "an article" about this, but want to show you some discovered facts:sorting the temporary file (fb_sort_nnnn.tmp and ib_sort_nnnn.tmp) mostly does writes, not reads (excluding database reads and fetching data from temp file). Firebird 2.1 read/write ratio is 1:10. InterBase 2009 read/write ratio is Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com1tag:blogger.com,1999:blog-9180090310744249219.post-31660451291154515042009-03-25T00:19:00.002+03:002009-03-25T00:45:13.120+03:00InterBase 2009 lost ODS 10.1 supportInterBase for years uses Y-valve, implemented by Jim Starkey, to support previous databases in new InterBase versions.The native ODS (On-Disk Structure) for the particular server version is the only one - the ODS of database created with this server. For example, native ODS for InterBase 6.0 is 10.0. For Firebird 1.5 - 10.1, etc.And, as a feature, InterBase and Firebird supports at least N-1 ODS Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-40197967153787480582009-02-10T13:24:00.002+03:002009-02-10T13:41:58.860+03:00Broken IndicesIBAnalyst since version 2.0 may report about broken or inconsistent indices. The detection of this cases is being made by checking index key count and record cound. If key count is less than records + versions, than the index is broken.How it can happen?At first, of course, it can happen when the database is broken, and some keys are missing. But the more realistic case for this inconsistency is Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-15294678455611498902008-11-12T17:16:00.003+03:002008-11-12T17:31:08.824+03:00FBScanner 2.1 is releasedWe are proud to announce the release of FBScanner 2.1. This version introduces a very interesting new features, such as plans extraction for queries, improved logging and tags support; these features make development and administration of Firebird and InterBase much more productive and effective. Read feature matrix and download trial of FBScanner 2.1 to estimate its value and effectiveness. Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-11925838563723164372008-10-16T18:28:00.002+04:002008-10-16T18:43:58.432+04:00Is Firebird Poor?This is a continuation of previous post about Firebird. Now I’d like to consider some facts about money flows around Firebird.First of all, a good question is how much money is being consumed by Firebird.The only public information is a set of reports from Firebird Foundation. The last public report is from 2007 year: http://firebirdsql.org/ffoundation/plenary/page_finance_agm2007.pdfFull set of Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com6tag:blogger.com,1999:blog-9180090310744249219.post-26991686687641867142008-10-15T15:54:00.003+04:002008-10-15T17:01:29.531+04:00What is Firebird?I’d like to clarify some facts about Firebird and Firebird Foundation. I think right now is a correct time to remind how all these things are organized, because some messages about "crisis, firebird's death, low finances" and so on being spreaded around.It seems that many people think that Firebird Foundations owns Firebird, makes development strategic/tactic decisions or something like this. Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com4tag:blogger.com,1999:blog-9180090310744249219.post-15591193561296956252008-09-16T22:06:00.002+04:002008-09-16T22:11:30.390+04:00FBCon 08 - 25-26-27 september - Bergamo - ItalyYou CAN'T miss FBCon 08 - 6th Firebird International Conference that will be held in Bergamo from 25 to 27 september. Conference will be from thursday september 25 till saturday Every day have a special theme with best italian and worldwide firebird-world expert!Here some of our sessions, for a detail go to www.firebirdconference.net:Italian sessions :CTE e query ricorsiveDatabase per sysdba – Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com1tag:blogger.com,1999:blog-9180090310744249219.post-7331949441207874032008-09-14T19:41:00.010+04:002008-09-15T12:22:43.631+04:00Multi-file Database ?Some last database repair cases we did were with multi-file databases. Interesting, that latest InterBase and Firebird versions was used, and also file system for the storage was NTFS, not FAT32 and FAT16. But, the databases was created and maintained using 1 gigabyte files.If you still use InterBase 5 and less, stop reading this, please :-)This is strange, because all InterBase and Firebird Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com1tag:blogger.com,1999:blog-9180090310744249219.post-89322515125180472962008-09-01T21:01:00.005+04:002008-09-14T07:07:39.756+04:00What page size I should use in my database?It's a common question with interesting background from developers . As I can suppose from IBSurgeon statistics, 99% of Firebird and InterBase developers use default page size: since the old ages it is 1024 bytes, and only for Firebird 2.0 it is changed to 4096 by default.There are 4 main things related with page size: indices depth, database cache size, records per page quantity and disk clusterDmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com4