Some simple performance Tests...
Posted: 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
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