Search results for "Newsletter 2026/07 D"

118 results found

IBExpert Benchmark Tool

The current version was released in January 2026, and includes some bugfixes, preventing the benchmark to crash on some servers.

We also have a new result, but it is just to measure the network speed between the client and server (we know that it does not show useful values when using the free benchmark as this version always using localhost as the server network address, but especially for the full version incorporated in the IBExpert IDE, it is very helpful to detect slow network configs to understand why Firebird-based applications run slower than expected. Outdated Router technology, network bridge components etc. are often responsible for poor software speed.

The Net Test executes 2000 inserts to a table with 100 columns and sends all params from client to the server in individual params, so this function will create a few hundred thousand very small TCP IP packages over the network and the total time is measured by how many operations were done within each second.

A good value on fast networks should have around >=400 IOPs. If it is much slower, you should ask your network support to check the speed of components used.

It is not part of the calculated percentage result values, and also the time it takes is not used there, since these result values use minimal network traffic to measure the server speed and not the network speed.

Benchmark results on an IFSLR Server using Ubuntu Linux 22 and Firebird 5

Compare your server's performance to our IFS servers!

How do you measure the performance of your own server or your clients'? Have you ever tried to compare the database speed of your Firebird server with new server hardware? Is a XEON Machine better than an Opteron? What improvements can you expect from fast SAS hard disks, RAID controllers or Enterprise SSDs?

This simple but effective tool gives you a reference benchmark, based on our recommended IFS Servers. Using IBExpert Benchmark you can generate and compare a reproducible speed index for your Firebird Server hardware. On average, our IFS servers with Firebird are 5 to 10 times faster than the server or virtual machines that our customers have previously used.

Benchmark (extended) results using Firebird 4.0 on an IFSML Server

To perform the IBExpert Benchmark at your customers and also take advantage of the extended and XXL benchmarks, you can use either the IBExpert Developer Studio customer version or the IBExpert Day Edition. To perform standard benchmarks locally, you may use our Free IBExpert Benchmark Tool.

back to top of page




Free IBExpert Benchmark Tool

You can use the IBExpert Benchmark Tool free of charge on any Windows computer. This limited special version allows standard benchmarks to be performed locally and includes Firebird 2.5, 3.0, 4.0 and 5.0 versions, executed in application mode, so you do not need to install Firebird on the server to be tested.

The Benchmark Tool is quick and easy to use: download it here: https://ibexpert.net/benchmark/setup_benchmark.exe, install it on the drive that you want to test.

https://www.ibexpert.net/ibe/uploads/Main/FreeBenchmark_2026.png

The Benchmark Tool tests 10 parallel running threads.

Running the benchmark will not overwrite any programs already in use, nor does it install anything, so you can safely run the benchmark on your server. The IBExpert Benchmark Tool does not use an existing Firebird installation and will only test the drive on which it is installed.

Select the Firebird version you wish to use for your benchmark in the left-hand panel: Firebird 2.5 Superserver, Firebird 3.0 Superserver or Firebird 4.0 Superserver. The selection in this free version has been limited so that even users with no Firebird knowledge or experience can easily perform this quick benchmark test.

The right-hand window in this free version is read-only. (In the paid version you can enter any and all of this information, e.g. define your own connection string and client library file).

Start the benchmark by clicking Start Benchmark in the bottom left-hand corner.

Important: you will need to install and run this as Admin.

Note: Should you receive an error message, please download and install the current version.

The benchmark process and results are explained below under How does it work?

If you would like a more flexible version of our Benchmark, which allows you to change various test options, test multiple drives, various Firebird instances or even perform a benchmark on a Linux operating system or remote servers, you should use the following Benchmark, included in all IBExpert customer version IDEs.

back to top of page




IBExpert Developer Studio Benchmark

This version offers standard, extended and XXL benchmarks, which can be performed on the Firebird 2.5 Superserver, Classic server, Superclassic server or Firebird 3.0 and Firebird 4.0 32- or 64-bit, Windows, Linux etc. either locally or remote. The Benchmark software is implemented as a 32-bit Windows software, but it can connect to any remote Firebird installation.

If you wish to collect the results for comparison with different hard and software combinations, enter a brief description of the configuration to be tested, along with the recipient email address for the statistic report.

Benchmark (extended) results using Firebird 4.0 on an IFSML Server

Then add the required database connection information - you need to set a new path for the newly generated database; if you specify the path of an existing database, you will receive a warning message:

Specify the Firebird client, as well as the user name and password (the standard SYSDBA and masterkey). Finally click Start benchmark to run the benchmark test.

IBExpert now creates the demo database, which always follows the same guidelines. It then executes the INITALL procedure in this database. Following this parallel threads are created, which attempt to input further orders into the database. Following the Drive Test, the CPU Test test then is executed.

The results are displayed in the lower window: the drive and the CPU index are percentage index values comparing to our our IFS Server v. 6.0 series, which we rated at the time at 100%.

If you have specified an email address, you will receive the results by mail, with the heading as specified in the Please add a short description of the Firebird server hard- and software field.

back to top of page




How does it work?

Based on a demo database, which is created automatically, the standard benchmark, which is also included in the Free IBExpert Benchmark Tool, runs approximately 8 million operations (individual insert/update/delete/select statements) using 10 simultaneous processes in 2 runs on databases created with different parameters to demonstrate the impact of the physical drive speed.

The extended benchmark uses 50 parallel processes (simulating 50 concurrent users) and the XXL benchmark simulates 250 concurrent users with its 250 simultaneous processes.

Drive Test

The Drive Test is simply creating a benchmark database from a script. Within the Drive Test we changed the value of the so-called cache buffers (DefaultDBCachePages in firebird.conf) to 50, the smallest value possible. Then a stored procedure is executed inside the database to generate a lot of test data. In the Drive Test approximately 850,000 operations (i.e. INSERT, UPDATE, DELETE, SELECT statements) are carried out. This really measures the speed of the drive, because of the low-level of cache that is being used, is responsible for making a lot of I/O operations on the external drive.

  • Create DB - shows the time in seconds that it takes to create the Demo database.
  • TMP - Temporary file management that is used when for example, Firebird does not have any indices, which it can use, or it needs to perform some GROUP BY, HAVING or similar instructions.
  • Thread test - this is the multi-threaded test. If you have for example a test on this machine, and you have 1 thread or 10 threads running, you will also see this running in the Task Manager. This can result in huge differences on different machines.
  • Result - the basic value that is calculated here displays the combined results of the drive test, and we compare this value to a server that was distributed by ourselves around 2010 which had 100% speed. In reality, when you test on typical customer machines, especially in virtual environments, you will often see values of as little as 30%. Typical values are often in the range of 100%-150%.

CPU Test

This category calculates the percentage value for multi-threaded CPU tests with 5000 pages cache result to better see the advantages when using Firebird 3. This means that it no longer needs any operations on the disk. You will see a much faster result. The Thread Test, the multi-threaded line - with this one 10 parallel threads are always executed, which means it generates several thousand new orders inside the Demo database simultaneously. The Threads value here is the most important value, when you later have to check whether the server is really fast. Only this Threads value is recalculated to the Thread Test.

Thread Test

The Thread Test simply we take the CPU Test / Threads value and recalculate it. Thread Test simply means that we take the CPU Test / Threads value and compare it to the original machine. This machine is compared to our original machine as an index value.

back to top of page




How do your results compare?

Compare your server's performance to our IFS servers! This simple but effective tool gives you a reference benchmark, based on our recommended IFS Servers.

Our servers will show you a typical Firebird 2.5 Superserver performance of at least 200% for the CPU and at least 200% for the HDD Test with our IFS server series), und using Firebird 3.0 at least 230% for the CPU and at least 500% for the HDD Test. Results under 100% indicate an outdated server performance.

Important: This benchmark gives you a value to compare several hardware or software configurations running the Firebird server.

You will notice a huge performance increase, when comparing a Windows environment mit a Linux environment on the same hardware. This is partially due to the Windows NTFS file system, which is standard on Windows.

If, for example, you want to restart the Benchmark, especially on virtual machines, we always recommend executing this Benchmark several times, because sometimes when you execute it again, you can achieve better or worse values. This can happen because other jobs are being executed by the virtual machine host.

If the results are poor, click in the results window. You will be automatically redirected to our homepage. Here you can view our current offers for our really fast IFS Firebird servers.

Changing the server to a more powerful hardware might improve the speed by 100%. Additionally optimizing your software and database operations can often improve the speed by more than 1000%. Ask register@ibexpert.net for further support. 


Firebird performance issues

How do you measure the performance of your own server or your clients'? Have you ever tried to compare the database speed of your Firebird server with new server hardware? Is a XEON Machine better than an Opteron? What improvements can you expect from fast SAS hard disks, RAID controllers or Enterprise SSDs?

The IBExpert Benchmark is a simple but effective tool, which gives you a reference benchmark, based on our recommended IFS Servers. Using IBExpert Benchmark you can generate and compare a reproducible speed index for your Firebird Server hardware. On average, our IFS servers with Firebird are 5 to 10 times faster than the server or virtual machines that our customers have previously used. 

Perform the comparison yourself using our free IBExpert benchmark software on your Firebird server: https://ibexpert.net/benchmark/setup_benchmark.exe

Read more


IBExpert Day Edition

(German-language version below)

The IBExpert Day Edition contains all the features of the IBExpert IDE, e.g. debugger, performance analysis and much more.

IBExpert can be used on registered computers for 24 hours following activation. After the 24 hour period IBExpert will no longer start on this computer, but can be activated again.

Use IBExpert wherever you or your employees work

In the home office
For customer support
On customer computers, e.g. as a supplement to the Company Year Edition

The automatic termination after 24 hours minimizes the risk of running an unlicensed product on customer machines.

Or for other tasks

Benchmark tests
Training purposes
Tests

Also as a cost-effective introduction

For your trainees and interns
And of course also for testing for new customers

And also at hand in case of emergency

For short-term use on another computer, e.g. if you cannot generate a removal code when moving to another computer, or your computer is broken.

IBExpert Day Edition Packages

There are a number of IBExpert Day Edition Packages. Please refer to our IBExpert products, services & prices page for details.

Please register in the IBExpert Download Center for this product with a valid e-mail address. If possible, use a use a company address such as support@companyx.com, ibexpertday@computerenterprise.com or similar.

The software activations are made available on your user account in the IBExpert Download Center for a period of 12 months from the date of purchase.

Afterwards any unused activations will automatically expire. To prevent this, you can purchase a new IBExpert Day Edition package before the expiry date, so that unused activations are credited for a further 12 months.

The IBExpert Day Edition is the ideal supplement to all IBExpert full versions, ready for use on all computers at any time.

The IBExpert Day Edition can also be run on Linux/Wine.

You can download the latest IBExpert IDE setup file from the IBExpert Download Center and distribute it with your software product. If you wish to work with IBExpert on your customer servers, activate one of your Day Editions with your e-mail address/password combination to start IBExpert.




IBExpert Day Edition

Die IBExpert Day Edition enthält alle Funktionen der IBExpert IDE, z.B. Debugger, Performanceanalyse u.v.m.

IBExpert kann nach der Freischaltung 24 Stunden auf dem Computer benutzt werden. Nach Ablauf von 24 Stunden wird IBExpert auf diesem Computer nicht mehr starten, kann aber erneut wieder freigeschaltet werden.

Benutzen Sie IBExpert überall dort, wo Sie oder Ihre Mitarbeiter arbeiten:

Im Office
Im Homeoffice
Im Kundensupport
Auf Kundenrechnern, z.B. als Ergänzung zur Company Year Edition

Durch das automatische Beenden nach 24 Stunden minimiert sich das Risiko, ein nicht lizenziertes Produkt auf Kundenrechnern zu betreiben

Oder für andere Aufgaben

Für Benchmarktests
Für Schulungszwecke
Für Tests

Auch als günstiger Einstieg

Für Ihre Auszubildenden und Praktikanten
Und natürlich auch zum Testen für Neukunden

Und auch im Notfall zur Hand

Für den kurzfristigen Einsatz auf einem anderen Computer, z.B., wenn Sie keinen Removal Code beim Umzug auf einen anderen Computer erzeugen können, oder Ihr Computer defekt ist.

IBExpert Day Edition Pakete

Es gibt eine Auswahl an IBExpert Day Edition Paketen. Bitte entnehmen Sie die Details unserer IBExpert Produkte, Dienstleistungen & Preise-Seite.

Bitte registrieren Sie sich im IBExpert Download Center für dieses Produkt mit einer gültigen E-Mail-Adresse. Verwenden Sie nach Möglichkeit eine Firmenadresse wie z.B.support@companyx.com, ibexpertday@computerenterprise.de oder ähnliches.

Die Freischaltungen erfolgen auf Ihrem User Account im IBExpert Download Center für einen Zeitraum von 12 Monaten ab Kaufdatum.

Nicht angeforderten Aktivierungen verfallen danach automatisch. Um dieses zu verhindern, können Sie rechtzeitig vor Ablauf ein neues IBExpert Day Edition Paket erwerben, damit werden nicht angeforderte Aktivierungen für die nächsten 12 Monate gutgeschrieben.

Die IBExpert Day Edition ist die ideale Ergänzung zu allen IBExpert Vollversionen, jederzeit auf allen Computern einsatzbereit.

Die IBExpert Day Edition ist auch mit Linux/Wine lauffähig.

Sie können die aktuelle IBExpert IDE-Setup-Datei im IBExpert Download Center herunterladen und mit Ihrem Software-Produkt verteilen. Wenn Sie mit IBExpert auf Ihren Kundenservern arbeiten möchten, aktivieren Sie eine Ihrer Day Editions mit Ihrer E-Mail-Adresse/Passwort Kombination, um IBExpert zu starten.


Current IBExpert version

View all new features of version 2026.11.03 here: What's New  


Whats New

IBExpert 2026.10.12

(and bugfix 2026.11.03)

1. "Goto column" feature in data grids

Available from the context menu, default shortcut is [Ctrl] + [Shift] + [G].

This feature shows a list of visible columns of a dataset with the possibility to filter them and focus a selected column.

It displays a small pop-up with an alphabetical, searchable list of all column headers. Select a column and the grid is focussed on that specific column without moving it or modifying the SQL query.

2. Highlighting of system tables in the windows bar. "System objects color" is used for highlighting.

3. Table selector 

- combobox on the toolbar with list of database tables - in the Table Editor it was replaced with bar button. Using that button you can choose another table for editing via improved "Select object" dialog wich supports schemas and filtering.

This is only for existing tables; there is still a combobox there for a new Table Editor.

This combobox will be replaced in all other editors that have it in future IBExpert versions.

4. Database Comparer

There are a lot of changes in the Database comparer to facilitate use with Firebird 6.


IBExpert 2026.07.26

(and bugfixes 2026.08.20)

This version includes further adaptations and optimisations to new Firebird 6 features, along with minor bugfixes and improvements.


IBExpert 2026.02.22

(and bugfixes 2026.03.01/2026.03.04/2026.03.15/2026.13.19/2026.03.31/2026.04.02/2026.05.22/2026.05.26/2026.05.28/2026.06.02)

The main improvement in this version is support for schemas in the Extract Metadata engine and everything around it: the Extract metadata feature itself, the ibec_ExtractMetadata function and other places where pFIBExtract is used. 


IBExpert 2025.08.04

(and bugfixes 2025.08.08/2025.10.29/2025.10.31/2025.11.07/2025.11.12/
2025.11.17/2025.12.19/2025.12.23)

1. SQL Editor

  • Support for CALL statement (FB 6).
  • Support for SHOW (WIRE_STATISTICS | WIRE_STATS) command (FB 6).
    The command show values of wire statistics counters, accumulated since the connection start time.

2. Database Inside

  • Initial support for FB 6 databases.

3. New trace session form

  • "Initial view mode" option implemented.

4. Other minor bugfixes and improvements


IBExpert 2025.06.09

(and bugfixes 2025.06.18/2025.06.24)

1. Initial support for Firebird 6 implemented

    2. Blob editor

    • Improvement: Two or more blob editors can now be opened at the same time.
      To start a second, third etc. blob editor use the "New blob editor" button in an already opened blob editor.

    3. SQL Editor

    • Improvement (Firebird 6): EXPLAIN <query> 
      - Prepares <query> and gets its plan in the usual way.
      - Executes "select * from rdb$sql.explain(<query>)" and shows results in the data grid.

    4. DB Explorer

    • Bugfix: Missing colorization of incremental search results if the database connection charset is UTF8.

    5. IBEBlock

    • Bugfix: ibec_CompareMetadata ignored stored functions and packages if Firebird 4.0 or Firebird 5.0 is specified as the server version. 
    • Improvement: FOR loop now supports DOWNTO and BY clauses similar to Firebird 6 syntax.

    6. Minor bugfixes and small improvements


    IBExpert 2024.12.01

    (and bugfixes 2024.12.04/2025.02.05/2025.02.27/2025.03.07/2025.03.28/2025.04.22/2025.05.08)

    1. Event blocks

    • "Before start trace session" event block implemented.
      See \Blocks\Templates\EventBlocks\TAS.BeforeStartTraceSession.ibeblock for an example.
      Also see description of new "Quick start trace session" feature below.

    2. Code editors

    • Support for multilevels in User actions submenu.
      See \Blocks\Templates\EventBlocks\CodeEditorUserActions.ibeblock for a working example.

    3. Database Comparer

    • Fixed the problem with missing stored functions and packages while comparing Firebird 5 databases.

    4. Quick start trace session feature implemented

    • This feature is intended to start a trace session for an active connection with a single click.
    • Default trace config is provided by IBExpert and can be modified in the "Before start trace session" event block which is fired when quick start or regular start (Services | Trace and Audit | Start new trace session) is performed.

      There are several other properties of trace session and trace form which can be customized in the "Before start trace session" event block.

      See \Blocks\Templates\EventBlocks\TAS.BeforeStartTraceSession.ibeblock for complete example.
    • To quick start a trace session, use the corresponding button on the main form tool button. Alternatively it can be done using the [Ctrl] + [Shift] + [T] shortcut.

    5. IBEBlock

    • ibec_psql_PreprocessPSQL function implemented.

      It inserts some placeholders in the form of single line comments into a provided PSQL source (procedures, functions, triggers and package routines) which can be later replaced with additional debug statements (INSERT into a log table etc.). For a complete example see \Blocks\DefaultBlocks\PSQL.PrepareForDebug.ibeblock.

      There is also a working implementation of calling this block from \Blocks\Templates\EventBlocks\ CodeEditorUserActions.ibeblock which performs the preparation of the PSQL source for debugging and removes debug statements and comments from the PSQL source when they are no longer needed.
    • @SysUtils.GetFilePath function implemented.

      The function sequentially checks the specified folders for the presence of the file. If the folder contains the specified file, the function returns the full path to it and exits. Otherwise, it returns NULL.

    Example:

        ...
        sBlockFileName = 'PSQL.PrepareForDebug.ibeblock';
        sBlockFilePath = @SysUtils.GetFilePath(sBlockFileName,
           ibec_GetEnvironmentVariable('IBE_USERBLOCKSDIR'),
         ibec_Coalesce(ibec_GetEnvironmentVariable('IBE_APPDIR'), '') + '\Blocks\DefaultBlocks');

      if (sBlockFilePath is null) then
      begin
        ibec_ShowMessage('Looks like ''' + sBlockFileName + '''is missing...');
        Exit;
        end; 

    6. Minor bugfixes and small improvements


    IBExpert 2024.04.07

    1. Database Registration

    "Show server version mismatch warning" option added (Additional tab). 

    If this option is ON (default) IBExpert will compare the specified and the actual version of the database and warn in case of a mismatch with a choice of possible actions.

    2. PSQL Debugger

    Support for time zones implemented (Firebird 4, 5). 

    3. Data Grids

    The possibility to dump blobs to file without preloading them into the IBExpert GUI has been implemented; it is available from the grid context menu.

    Fixed the issue with incorrect representation of RDB$DB_KEY for tables with >2G records. 

    4. Code Completion

    Fixed the incorrect behaviour when selecting/unselecting items in the list using the mouse. 

    5. Database Inside

    Support for Firebird 5 databases. 

    6. SQL Editor, Statements History List

    Added counters for page operations. 

    7. Database Comparer

    Support for parenthesized SELECTs (Firebird 5) implemented. 

    8. Other minor bugfixes and small improvements


    IBExpert 2024.01.22

    Mainly bug fixes.


    IBExpert 2023.11.22

    Mainly bug fixes.


    IBExpert 2023.10.27

    1. Code Editor, Code Completion

    • Improved performance especially on databases with lot of objects.
    • Suggesting possible joins based on existing relationships by foreign keys - call the Code Completion after JOIN keyword.
    • There was a bug on some configurations in the previous version which caused IBExpert to freeze when the Code Completion is fires. Fixed in this version.

    2. Database Inside

    • Support for Firebird 4 databases.

    3. Partial support for Firebird 5 implemented

    • Support for all known syntax changes/additions in the PSQL parser:
         SKIP LOCKED, WHEN NOT MATCHED BY SOURCE, parenthesized SELECTs etc.

         However, there is NO support yet for parenthesized SELECTs in the Database Comparer.
         Also the PSQL debugger doesn't allow to debug roitines with subroutines which reference variables in a main routine.

    • Support for new built-in functions in the Code Parameters hint.
    • Support for partial indices in the index editors and metadata extract.
    • Support for parallel workers in following IBEBlock functions:
        ibec_BackupDatabase, ibec_RestoreDatabase, @Services.RepairDatabase.

          There is a new option available - ParallelWorkers (or just Parallel) - which allows to specify number of parallel workers (e.g. ParallelWorkers=4)

    4. Other minor bugfixes and small improvements


    IBExpert 2023.09.13

    Mainly bug fixes.


    IBExpert 2023.07.09

    1. DB Explorer

    •   Activating/deactivating database objects from the Project View tree.

    2. Search in Metadata

    •   Possibility to search in scripts/blocks (IBE$SCRIPTS table) has been implemented.

    3. Code Editors

    •  Hyperlinks behaviour for package routines implemented.
    • "Before load from file" event block implemented. This block allows you to perform some actions before the appearance of the "Open file" dialog; for example, change a source directory. See block template for more details.
    • "Init/perform user actions" event block implemented. This block allows you to define user actions with code editor content which will be executed via a shortcut and/or from the code editor context menu (the very first item in the menu, if the block exists and is active). See block template for more details.

    4. Dependencies trees

    •   Solved some issues with the incorrect display of package dependencies.

    5. Copy Database Object

    • Support of SQL role in copy blocks added.

    6. IBEBlock

    • @Services.RepairDatabase and @Services.SetDBProperties functions implemented. 

        Example:

        execute ibeblock
        as
       begin
         -- Both functions return nothing (NULL) if there were no errors,
         -- otherwise they will return an error message 

         sDBName = 'dbserver/3053:D:\databases\db.fdb';
          sConnectParams = 'ClientLib="D:\ClientLibs\fbclient_30.dll"; User=SYSDBA; Password=masterkey;';

        -- Supported repair params: Limbo, CheckDB, IgnoreChecksum,
          -- KillShadows, Mend, Sweep, Validate, ValidateFull

          Res = @Services.RepairDatabase(:sDBName, :sConnectParams || 'Mend');

         if (Res is not null) then
           ibec_ShowMessage(Res); 

          -- All supported params are listed in the example

          Res = @Services.SetDBProperties(:sDBName, :sConnectParams || 'PageBuffers=2048; SQLDialect=3;
               SweepInterval=20000; ForcedWrites=TRUE; ReadOnly=FALSE');

         if (Res is not null) then
            ibec_ShowMessage(Res);

        end;

    • ibec_ExtractMetadata function:
      ExtractPrimaryKeys and ExtractUniques options added to prevent extraction of primary keys and unique constraints. Together with the existing ExtractReferences and ExtractChecks these options allow you to suppress the extraction of all constraints.

      By default all of these options are ON (TRUE). To disable the extraction of primary keys, for example, set the corresponding option to FALSE: ExtractPrimaryKeys=FALSE.

    • Code Editor namespace with set of functions implemented. See example of usage in the "Init/perform user actions" event block template.

    7. Minor bugfixes and small improvements


    IBExpert 2023.04.14

    Minor bugfixes and small improvements.


    IBExpert 2023.03.06

     1. Data Grid

    • Possibility to edit UUID/OCTETS values in the filter criteria tree has been implemented.
    • The mouse wheel can now be used to perform Page Up and Page Down actions.
    • By default the Ctrl key should be held to perform PageUp/PageDown.
    • To change the default modifier put the following piece of code into the After IBExpert starts event block:
        ibec_SetGlobalVar('IBE$DATA_GRID_PAGE_SCROLL_MODIFIER', <value>);

            where <value> is one of following: empty string, null, 'CTRL', 'ALT', 'SHIFT'.

            An empty string or null as a new modifier value makes PageDown/PageUp a default                behaviour of the mouse wheel in the Data Grid.

    2. Code Editor

    • Support of keyboard templates in the Code Completion list.
      There is a new option Show keyboard templates in Code Completion list in the Options | Editor Options | Code Insight.

    3. Automatic restore of a dead connection

    • By default if the database connection is lost IBExpert shows a dialog window and offers to restore a dead connection. To attempt to restore the connection automatically without user confirmation put following line of code into the After IBExpert starts event block:
        ibec_SetGlobalVar('IBE$RESTORE_DEAD_CONNECTION', TRUE);

    4. Database Object Editors

    • Support of object names longer than 31 chars (Firebird 4) where they were not yet supported.

    5. Export Data

    • Export to clipboard in JSON format implemented.

    6. Code Formatter

    • Support of space after opening and before closing bracket options.

    7. Minor bugfixes and small improvements


    Monitoring

    (German-language version below)

    IBExpert Firebird SQL Performance Monitoring
    Your way out of the blind alley

    The situation

    • You are using Firebird-based software
    • The benchmark shows that your hardware attains a reasonable speed and yet certain queries in your software take much longer than acceptable
    • The server becomes slower and slower, but speeds up again after rebooting
    • The time required for certain queries or software reaction time in dialogs varies

    The blind alley

    It is becoming increasingly difficult to work effectively with the software, but the software provider claims that this is not the fault of his software, but of your hardware, your operating system or your network etc.

    Your software manufacturer provides no beneficial support, instead you have to listen to claims that you are the only one who has this problem, all other customers are satisfied.

    By now you begin to doubt that the software provider is taking your concerns seriously at all.

    The solution

    You commission us to take a look behind the scenes, to support you in your discussions with your software provider, and to counter the repetitive excuses with objective reasoning.

    With our tools and our experience we examine not only the hardware and operating system in use, but also what the database needs to handle in terms of the application’s SQL queries.

    We are often rapidly able to detect SQL commands, which do not use appropriate indices or are poorly formulated.

    As the size of the database increases, these effects become more and more severe, and when the data volume doubles, the SQL commands will not just take twice as long to execute, but considerably longer.

    An isolated test of a query on the programmer's fast laptop, which may use only part of the database, but does not have to process queries from 20-50 or more other workstations, only helps to pass the buck to you again.

    With our help, you can quickly detect whether this query or screen reaction time is at all representative of your issues.

    IBExpert Firebird SQL Performance Monitoring together with our support provides a way out of this blind alley in discussions with your software provider.

    Improvements

    We will show you where bottlenecks occur in your system and how well your hardware/software fits and interacts with your working environment.

    We can offer you and/or your software provider concrete advice on what could be improved, in order to achieve optimum performance of your Firebird database systems and software, even with large-scale customer implementations and data volumes.

    Whether it is a matter of indices, optimized SQL queries or general tips and tricks, we see ourselves as a moderator between yourself and your software provider.

    If, as in almost all cases where we have already successfully implemented monitoring, the software provider is prepared to work with us constructively, then you will often see significant progress already in the next software update.

    We also examine your application at network protocol level, because often data is retrieved over the network that is not visible anywhere in the application software. The developer is often not even aware of this problem until we point it out to him with specific examples and offer workarounds to avoid it.

    Our services

    Let us, as database experts, analyse your database system and propose improvements to optimise performance. You will find that our wealth of experience will certainly offer you new aspects, so that you and your software provider will be in a position to optimize your database system.

    Our common goal should be to create an optimal working environment without making poor compromises and seeking solutions, also from your software provider.

    We offer our IBExpert Firebird SQL Performance Monitoring for the price of 1,200 Euros: IBExpert Firebird SQL Performance Monitoring.

    Following receipt of payment we will arrange a date to start our analysis by remote maintenance and will normally let the monitoring run for 7 days or longer if desired.

    You will receive a detailed report by e-mail within 72 hours following the completion of the monitoring.

    Our standard offer is valid for Firebird 2.5 and upwards. For older Firebird versions please request an offer from register@ibexpert.net. 


    IBExpert Firebird SQL Performance Monitoring
    Ihr Ausweg aus der Sackgasse

    Das Szenario

    • Sie setzen eine Firebird basierende Software ein
    • Der Benchmark zeigt, dass Ihre Hardware eine akzeptable Geschwindigkeit erreicht und trotzdem dauern bestimmte Abfragen in Ihrer Software erheblich länger als man erwarten würde
    • Der Server wird immer langsamer und ist aber nach einem Neustart wieder schneller
    • Die Zeiten für bestimmte Abfragen oder Maskenaufbau sind unterschiedlich lang

    Die Sackgasse

    Ein effektives Arbeiten mit der Software wird immer schwieriger, aber der Softwarehersteller behauptet, das liegt nicht an seiner Software, sondern an Ihrer Hardware, an Ihrem Betriebssystem oder an Ihrem Netzwerk etc.

    Ihr Softwarehersteller hilft Ihnen nicht und Sie müssen sich immer wieder anhören, dass Sie der einzige sind, der dieses Problem hat, alle anderen Kunden sind glücklich.

    Sie zweifeln mittlerweile daran, dass der Softwarehersteller Ihre Einwände überhaupt ernst nimmt.

    Die Lösung

    Sie beauftragen uns, denn wir schauen hinter die Kulissen, um Ihnen in der Diskussion mit Ihrem Softwarehersteller mit Rat und Tat zur Seite zu stehen, und um die wiederholten Ausreden mit Argumenten außer Kraft zu setzen.

    Mit unseren Werkzeugen und unserer Erfahrung prüfen wir neben der von Ihnen eingesetzten Hardware- und Betriebssystem-Kombination auch das, was die Datenbank an SQL-Abfragen der Anwendungsprogramme alles beantworten muss.

    Oft erkennen wir sehr schnell SQL-Befehle, die keine passenden Indizes benutzen oder einfach nur in der Abfragesprache nicht sauber formuliert sind.

    Mit zunehmender Datenbankgröße werden dann diese Auswirkungen immer heftiger und sämtliche SQL-Befehle werden bei Verdoppelung der Datenmenge oft nicht nur die doppelte Zeit brauchen, sondern wesentlich länger.

    Ein isolierter Test einer Abfrage auf dem schnellen Laptop des Programmierers, der möglicherweise auch nur einen Teil der Datenbank dafür benutzt, aber keinesfalls Abfragen von 20-50 oder mehr anderen Arbeitsstationen bearbeiten muss, hilft dabei nur dem Softwarehersteller, Ihnen wieder den schwarzen Peter zuzuschieben.

    Ob diese gezeigte Abfrage oder Maske überhaupt Ihr Problem darstellt, werden sie mit unserer Hilfe sehr schnell feststellen.

    Das IBExpert Firebird SQL Performance Monitoring liefert Ihnen mit unserer Hilfe bei der Diskussion mit Ihrem Softwarehersteller einen Ausweg aus dieser Sackgasse.

    Verbesserungen

    Wir werden Ihnen aufzeigen, wo die Engpässe in Ihrem System liegen und wie gut Hard-/Software in Ihre Arbeitsumgebung passen und zusammenspielen.


    Benchmark Ergebnisse mit Firebird 3.0
    auf einem IFSLR Server

    Sie und/oder Ihr Softwarehersteller bekommen von uns konkrete Hinweise, was verbessert werden sollte, um im Zusammenspiel von Firebird Datenbanksystemen mit Ihrer Software auch bei größeren Kundeninstallationen und Datenmengen eine optimale Performance zu erhalten.

    Ob es dabei um Indizes geht, bessere SQL-Abfragen oder generelle Tipps und Tricks. Wir sehen uns als Moderator zwischen Ihnen und dem Softwarehersteller.

    Wenn der Softwarehersteller, wie in fast allen Fällen, bei denen wir das Monitoring bereits erfolgreich umgesetzt haben, konstruktiv mit uns zusammenarbeitet, dann werden Sie oft bereits im nächsten Release-Update der Software deutliche Fortschritte feststellen.

    Wir untersuchen Ihre Applikation auch auf Netzwerkprotokollebene, weil oft Daten bereits über das Netzwerk abgerufen werden, die in der Anwendungssoftware nirgendwo angezeigt werden.

    Der Programmierer ist sich dieses Problems oft gar nicht bewusst, bis wir ihn darauf mit konkreten Beispielen hinweisen und Workarounds anbieten, mit denen er das vermeiden kann.

    Unsere Dienstleistung

    Lassen Sie uns als Datenbankexperten Ihr Datenbanksystem analysieren, um Ihr System für eine optimale Performance zu verbessern. Sie werden sehen, dass unser Erfahrungsschatz sicher auch Ihnen neue Aspekte vermitteln wird, so dass Sie und Ihr Softwarehaus in der Lage sein werden, Ihr Datenbanksystem optimieren zu können.

    Unser gemeinsames Ziel soll es sein, eine optimale Arbeitsumgebung zu schaffen, ohne faule Kompromisse und ehrliche Antworten zu finden, auch von Ihrem Softwarehaus.

    Wir bieten Ihnen unser IBExpert Firebird SQL Performance Monitoring zum Preis von 1200 Euro. Bestellen Sie per mail an: register@ibexpert.net. 

    Nach Zahlungseingang starten wird das Monitoring zu einem vereinbarten Termin per Fernwartung und lassen es üblicherweise 7 Tage, oder auf Wunsch auch länger, laufen.

    Nach Ende des Monitorings erhalten Sie innerhalb von 72 Stunden einen ausführlichen Bericht per E-Mail.

    Unser Standard Angebot ist nur gültig für alle Firebird Versionen ab Firebird 2.5. Für ältere Firebird Versionen fragen Sie bitte unser Angebot an: register@ibexpert.net.