New article: Start working with Firebird

IBProvider announce the artcile: Start working with Firebird
 
Table of content:
————————————————————————————-
What is Firebird SQL Server?
What Firebird version to choose?
Firebird installation: choosing server type
       Firebird Super Server
       Firebird Classic Server
       Firebird Embedded
       If it is difficult to choose
Start working with Firebird
      New Firebird database creation
Firebird security
      SYSDBA User. Changing default password
Connection to Firebird from client’s application
     Firebird and VBScript, Visual Basic, VBA
     Firebird and Delphi
     Firebird and .Net
     Firebird and C++
Firebird database editing
    The List of Firebird administration utilities
Useful links

Original manual: Firebird

rfc: TRUNCATE TABLE in Firebird

Vlad Khorsun posted on Firebird-Architect

One of the often task in ETL applications is to quick erase all data in some table(s). Often amount of data is big or huge (tens of millions records). In Firebird we have two choices currently – DELETE all rows or RECREATE TABLE. Both have its own drawbacks. DELETE produced a lot of record versions to clean up, its slow as works row-by-row basis and fire triggers which is almost always is not needed. RECREATE is free from this drawbacks but it will fail if there is dependencies and all related objects such as triggers, indices, constraints must be recreated too. Read more

1 44 45 46 47 48 78