Optimizing a Delphi 2009 app using Firebird 2.5 Alpha 1

The last few days I’ve spent optimizing an application written in Delphi 2009 that talks to a Firebird database using the standard TIBDatabase, TIBTransaction and TIBSQL components The application needs to do alot of reading/writing to the database, and was rather slow so I had to optimize it a little …The application is basically an Indy based Web-Server that receives simple GET parameters, does a thing or two in the DB and returns with the Success/Fail and a possible result from the DB.

Access to Firebird from Delphi using dbGo components

The new article was published: Working with Firebird and Interbase from Delphi using IBPRovider and dbGo components.

Table of content:

  • TADOConnection component
  • TADOTable component
  • TADODataSet component
  • Sending changes to database – updatable rowsets technology
  • Client and server cursors
  • What provider to choose?
  • TADOQuery component
  • SQL-queries with parameters
  • TADOStoredProc component
  • TADOCommand component
  • Transactions

TurboCASH 4: Release Candidate1

The TurboCASH Project is proud to present our Release Candidate 1 for TurboCASH 4.0.1.10 This is the culmination of a years preparation to move TurboCASH to a new platform based on the Firebird database. 
 
This release has been prepared to ship to 81 countries. The biggest change we have made here is to open up the the code for the input of a greater number of contributors. The plugin architecture has been widened to include Delphi dlls. 
 
The program sports a revised user interface and improves data accessability. Included now is the Reportman Database reporter. TurboCASH 4 can run from a singel user embedded on a memory stick right up to 50 Plus users. 

1 4 5 6 7 8