Re: Wanted: TDataset Sybase SQL Anywhere connectivity, no dbExpress

Can you give me a list/examples?

- rowset fetching. It gives good speed. Some time ago, I have performed
benchmarks for few Oracle data access libraries, including AnyDAC.
Results are there - http://www.da-soft.com/images/content/perf_results.gif.
Important things there: SQLDirect TSDQuery does not use rowset fetching.
And you can see on Fetch All (no BLOBs) it is the same slow as
ODBCExpress "MS TOEQuery". So, I can imagine, ODBCExpress does not
use rowset fetching too. If so, it will fetchi slow on Sybase ASA too, because
ODBC API is the same for Oracle and Sybase ASA.

- array DML. And IMHO ODBCExpress does not support it too.
It allows the effective move of large data arrays from the client to the DB.
On Sybase ASA it gives ~10 time performance gain, comparing to classic
ExecSQL, but with same complexity of code.

- the uniform support for escape sequences across all AnyDAC drivers,
including ASA one.

- full support for editing of identity fields, with automatic recognition of
these fields and automatic refreshing of identity fields after record
insertion.

- pessimistic locking at data editing. Optimistic is another option.

- automatic messages receiving from ASA message callback.

- automatic error messages parsing and extracting from them object
names, getting AnyDAC unified error code (like a ekRecordLocked).

- full set of AnyDAC QA tests for Sybase ASA.

..... and **a lot more** features.

Regards,
Dmitry

--
Dmitry Arefiev - www.da-soft.com
AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase
ASA, DbExpress, ODBC freeware data access engine
ThinDAC - multitier data access engine

.

Relevant Pages