Some simple performance Tests...

Joao Cadilhe · Post by **Joao Cadilhe** » Thu 27 Mar 2008 16:21

I did some tests (local machine) comparing Ado (DbGo), UniDac, FibPlus, using Delphi 2007 Professional + December Update and populate one table with 28000 records (Firebird 2.1 and SqlServer Express 2005).

Results (SELECT * FROM TABLE):

Firebird 2.1 Beta 2:

1) ADO (dbGo - IbProvider Freeware) - Server Cursor, FowardOnly:
AdoQuery + Datasetprovider + ClientDataset: 1.0160 sec.

2) FibPlus (Unidirectional = True):
FibDataset + Datasetprovider + ClientDataset: 0.6410 sec.

3) DbExpress (Delphi 2007 native Interbase dll):
SqlQuery + Datasetprovider + ClientDataset: 0.4680 sec.

4) Unidac (ReadOnly)
UniQuery + Datasetprovider + ClientDataset: 0.4220 sec.

SQLServer Express 2005:

1) ADO (dbGo) - Server Cursor, FowardOnly:
AdoQuery + Datasetprovider + ClientDataset: 1.0470 sec.

2) Unidac (ReadOnly)
UniQuery + Datasetprovider + ClientDataset: 0.4530 sec.

I repeated the tests three times and considered the last test values (because of database query cache operations).

Do you know something about final UniDac release date?

Thanks.

Joao Cadilhe

Challenger · Post by **Challenger** » Fri 28 Mar 2008 15:23

Yesterday we released UniDAC Beta 3 with all providers supported. We plan to release the final version of UniDAC in about three weeks.