the help system, simply type HELP at the prompt, as shown below (from Firebird 4.0): SQL> help; Frontend commands: BLOBDUMP -- dump BLOB to a file BLOBVIEW -- view BLOB SET SQL DIALECT -- set sql dialect to SET STATs -- toggle display of performance statistics SET TIME -- toggle display of timestamp with DATE values SET TERM available commands by typing the help command which will produce the following output: SQL> help; Frontend commands: BLOBDUMP -- dump BLOB to a file BLOBVIEW -- view BLOB

multi-processor) sup- port. Better performance in case of a small number of connections that do not influ- ence each other. No SMP support. On multi-processor Win- dows machines, performance can even drop dramatically events with a firewall or tunnel). In most circumstances, chances are that you won't notice a performance difference. Note that you can always switch to the other architecture later; your applications configuration is forced writes off (or disabled). It is sometimes resorted to in order to improve performance during large batch operations. Disabling forced writes on Windows The big warning here is: do

allocated to store (cache) database pages in memory to help improve the efficiency of the database performance. It is far quicker to read data from memory that it is to have to physically read the data from  Please don’t consider page buffers value as an ultimate parameter to improve Firebird’s performance, and don’t set it too high without clear understanding what are you doing. The setting applies page becoming completely empty, then it can be used for any purpose within the database. • The performance of the database may be affected while the sweep is in progress.  Theoretically, it is possible

configuration is forced writes off (or disabled). It is sometimes resorted to in an attempt to improve performance during large batch operations. Chapter 7. Protecting your data 40 Disabling forced writes on Chapter 8. How to get help 42 Chapter 9. How to give help Firebird exists, and continues to be improved, thanks to a community of volunteers who donate their time and skills to bring you this wonderful

in triggers for adding and updating data. It may reduce the performance of inserting/updating records, but it will increase the performance of data selection. Defining an ARRAY Column • If the column parameters were unchanged. Enhanced Performance since stored procedures are executed on a server instead of at the client, network traffic is reduced, which improves performance. 7.2.2. Types of Stored Procedures to discover whether tables or columns have been dropped 3. Even though the performance in loops has been significantly improved in Firebird 2.5, execution is still considerably slower than when the same

Client-seitigem SQL verwendet werden (es sei denn, die Client-Anwendung ist eine isql-Oberfläche oder Frontend). PSQL intvar = GEN_ID( GeneratorName, 0 ); Firebird 2: Gleiche Syntax. 3.2.3. Den nächsten

caches) open after the last connection to that database was closed. This can help to improve performance at low cost, when the database is opened and closed frequently, by keeping resources “warm” for in triggers for adding and updating data. It may reduce the performance of inserting/updating records, but it will increase the performance of data selection. Defining an Array Column • If the column parameters were unchanged. Enhanced Performance since stored procedures are executed on a server instead of at the client, network traffic is reduced, which improves performance. 7.2.2. Types of Stored Procedures

easy to use as old-style UDFs. 13.3. Improvements in Firebird 2 Firebird 2 comes with a somewhat improved calling mechanism for old-style UDFs. The engine will now pass NULL input as a null pointer to with one or more of the functions listed above under Firebird 2, and you want to benefit from the improved NULL handling, run the script ib_udf_upgrade.sql Chapter 13. User-Defined Functions (UDFs) 39

tion License from now on. 1.2 28 Feb 2005 PV Renamed Conclusion to Afterword (less ambiguous). Improved rendering of tables; added note on possible hyphens in tables. 1.2.1 8 April 2005 PV Added titleabbrev

ID to wireprotocol. 0.8 17 Jun 2004 Added two new segmendted lists. 0.9 18 Jun 2004 • Improved segmentedlist usage. • Fixed rendering of important tags. 0.1 0 19 Jun 2004 Changed rendering