Offical ZeoLib 7.2-Beta has been released

[BigChimp]

Well, the documentation suggests otherwise.

[EgonHugeist]

@mangakissa

Please .... I'd announce 7.2-Beta. I've been trying to show the advantages of the new version.
What i want: more test-users to have a nice Stable-candidate later.

I didn't judge badly about the expencive components. And i did reference the external Synopse.info tests because (from my point of view) this is the best advertising we could get for my done work.

Of course DevArt wrote some Library replacement. They don't need the libmysql-library to connect to MySQL. But AFAIK initial idea behind is the MySQL-Licence politic it's selves and avoiding installation issues.
Now MariaDB 10.0 is availible, for free, i'd testet the server and library with 7.2 and i can say current SVN-Version can be used safely. So we can use the MariaDB libmysql-library instead of the MySQL once. The MySQL licence issues are resolved from my point of view.

You can use what ever you want!

So let's stay professional.
Just study http://blog.synopse.info/post/2013/11/04/Updated-mORMot-database-benchmark-including-MS-SQL
It might be possible MyDAC performance better! Or AB simply miss to set some parameters for better performance! Feel free to help him. I'm sure Arnaud is happy if you can support him a bit with the DevArt components.

Comparing Zeos-7.1, FireDac, Unidac(DevArt too) ....... IMHO numbers are talking. THIS really was a hard judgement for Zeos-7.1!

Than read final statement about 7.2:

@EgonHugeist

Now direct Zeos/ZDBC access is clearly the fastest way of using external SQL databases with mORMot.
For both writing and reading - and especially at reading, where by-passing DB.pas and its TDataSet bottleneck makes ZDBC 2.5 times faster than the expensive FireDAC!

Code: [Select]

Insertion speed

Direct Batch Trans Batch Trans
SQLite3 (file full) 439 28715 67945 170259
SQLite3 (file off) 2060 87587 87556 194099
SQLite3 (file off exc) 24311 191000 88328 201661
SQLite3 (mem) 71484 228958 91606 225794
TObjectList (static) 280835 439521 269396 435502
TObjectList (virtual) 273972 439908 266880 438865
SQLite3 (ext full) 498 12472 84984 151666
SQLite3 (ext off) 2271 42367 93231 172205
SQLite3 (ext off exc) 23557 150132 94655 171291
SQLite3 (ext mem) 81559 205187 95796 205482
ODBC SQLite3 575 11936 33537 75480
ZEOS SQlite3 488 13143 44595 81663
FireDAC SQlite3 18684 38913 37886 106107
ODBC Firebird 980 15392 10051 14874
ZEOS Firebird 10395 54686 22504 52468
FireDAC Firebird 20150 49276 20291 49057
MSSQL2012 local 4234 42164 12292 57905
ODBC MSSQL2012 4054 7737 11171 9083
FireDAC MSSQL2012 3788 5729 9565 40822
ZEOS PostgreSQL 3029 30152 7837 45173
ODBC PostgreSQL 2842 29689 3862 32583
FireDAC PostgreSQL 2922 28586 7157 29408

Read speed
  By one Virtual Direct
SQLite3 (file full) 108811 480030 484496
SQLite3 (file off) 109361 478285 444049
SQLite3 (file off exc) 108429 476917 460744
SQLite3 (mem) 110392 478377 479984
TObjectList (static) 264466 831393 826993
TObjectList (virtual) 261684 359195 821692
SQLite3 (ext full) 115711 224024 464727
SQLite3 (ext off) 113273 228050 477600
SQLite3 (ext off exc) 115364 228550 477920
SQLite3 (ext mem) 115489 225032 475059
ODBC SQLite3 16297 113345 163089
ZEOS SQlite3 35073 168947 254439
FireDAC SQlite3 7951 76751 103887
ODBC Firebird 2015 60124 84109
ZEOS Firebird 21014 81447 109356
FireDAC Firebird 2227 53680 60292
MSSQL2012 local 8721 184311 292431
ODBC MSSQL2012 12064 116273 195472
FireDAC MSSQL2012 3908 91830 131337
ZEOS PostgreSQL 7296 131748 181310
ODBC PostgreSQL 7633 66365 92448
FireDAC PostgreSQL 1889 54675 73219

Clearly, 7.2 branch did achieve a huge performance boost.
You did a great job!

Note FireDac + SQLite is playing a unfair game. You can top the FireDac performance with Zeos7.2 by adding:

Code: [Select]

'synchronous=0'
'locking_mode=EXCLUSIVE'
To the TZConnection/TZURL.Properties. Than we nearly reach performance of Synopse "SQLite3 (file off exc)" implementations.

So if you compare 7.1 against 7.2... Numbers are talking! But don't forget ZDBC is not the TDataSet-layer... But the performance diffs with e.g. TZQuery of 7.1 and 7.2 are impresive TOO!

Sade: He didn't include UniDac again, Oracle tests are missing too. 

@Marcov & BigChimp
Thanks for your researches..

@ALL
Feel free to attach some camparision numbers!