|
|
|
|
| This driver is designed for use with Borland dbExpress components and provides direct high performance access to Informix database server. The driver uses Informix Client API without any intermediate layers like BDE or ADO this ensures an excellent performance and reliability. Luxena dbExpress driver for Informix Pro is a very good alternative to BDE and ADO |
|
|
|
|
|
|
|
 |
Wider Informix data types support |
| driver Pro has a wide Informix data types support, including new data types of Informix 9. Checkout supported data types comparison table. |
|
|
|
|
Significant better performance |
| driver Pro substantially beats Borland's driver in majority of performance tests. Checkout performance comparison table. |
|
|
|
|
Extensive compatibility with variety of Informix servers |
driver Pro is compatible with:
- Informix SE;
- Informix Dynamic Server 7;
- Informix Dynamic Server 9;
- Informix Dynamic Server 10.
Borland's driver supports only Informix Dynamic Server 9 and 10. |
|
|
|
|
Exclusive advanced features and functionality |
- query execution break;
- AutoCommit parameter for databases in the ANSI logging mode;
- access to diagnostic information via Informix connection area structure.
None of these features are supported by Borland's driver. |
|
|
|
|
Connection string feature |
Allows developers flexible configure driver parameters, including all setnet32 parameters and peculiar driver's parameters that affects performance, transaction management, etc. and are not available through standard dbExpress configuration.
Avoids configuration constraints that are common to standard dbExpress configuration by TSQLConnection.Params. For example, it is possible to force driver to trim chars in Delphi 6, where Trim Char configuration parameter is absent in dbExpress configuration.
With connection string developers are able to specify all Informix Connect parameters needed for connection without configuring Informix connectivity software. This feature makes the deploying of applications much easier allowing installation of the client without configuration of Informix Client. |
|
|
|
|
Robust and trustworthy |
Owing to dbExpress driver for Informix Lite (Pro's predecessor) this brand new driver has bugless, predictable and stable behavior.
This statement has been proven by using dbExpress driver for Informix Lite virtually in every possible kind of VCL applications - ordinary client-server, COM-based multithreaded application servers with number of remote clients, DataSnap and WebSnap based application and more. |
|
|
|
| Data type |
Luxena driver Pro |
Borland driver |
Luxena driver Lite |
| char |
ftFixedChar |
ftFixedChar |
ftFixedChar |
| small int |
ftSmallint |
ftSmallint |
ftSmallint |
| int |
ftInteger |
ftInteger |
ftInteger |
| float |
ftFloat |
ftFloat |
ftFloat |
| small float |
ftFloat |
ftFloat |
ftFloat |
| decimal(P) |
ftFloat | ftBcd(32,16) |
ftFMTBcd(32,16) |
not supported |
ftFMTBcd(32,16) |
| decimal(P,S) |
ftFloat | ftBcd(P,S) |
ftFMTBcd(P,S) |
ftFMTBcd(P,S) |
ftFMTBcd(P,S) |
| serial |
ftInteger |
ftInteger |
ftInteger |
| date |
ftDate |
ftDate |
ftDate |
| money(P,S) |
ftCurrency | ftFloat |
ftBcd(P,S) | ftFMTBcd(P,S) |
ftFMTBcd(P,S) |
ftCurrency |
| datetime |
ftTimeStamp |
ftTimeStamp |
ftTimeStamp |
| byte |
ftBlob |
ftBlob |
ftBlob |
| text |
ftMemo |
ftMemo |
ftMemo |
| varchar |
ftString |
ftString |
ftString |
| interval |
ftString |
ftString |
ftString |
| nchar |
ftFixedChar |
ftFixedChar |
ftFixedChar |
| nvarchar |
ftString |
ftString |
ftString |
| int8 |
ftFloat | ftBcd(20,0) |
ftFMTBcd(20,0) |
not supported |
not supported |
| serial8 |
ftFloat | ftBcd(20,0) |
ftFMTBcd(20,0) |
not supported |
not supported |
| set |
ftFmtMemo |
not supported |
not supported |
| multiset |
ftFmtMemo |
not supported |
not supported |
| list |
ftFmtMemo |
not supported |
not supported |
| row |
ftFmtMemo |
not supported |
not supported |
| collection |
ftFmtMemo |
not supported |
not supported |
| blob |
ftOraBlob |
ftOraBlob |
not supported |
| clob |
ftOraClob |
ftOraClob |
not supported |
| lvarchar |
ftString | ftFmtMemo |
not supported |
not supported |
| boolean |
ftBoolean |
ftBoolean |
not supported |
|
|
|
| SQL select of |
Luxena driver Pro vs. Borland driver |
| simple types |
~39% faster |
| requiring conversion simple types |
~3 times faster |
| simple large objects |
~5% faster |
| smart large objects |
~2.5 times faster |
|
peformance test description
here... 
|
|
|
|
|