Zeos 7.3 testers-thread

[miab3]

ZEOS 8.0.0 /trunk svn 7799
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.0.0(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.2.0(fpc 3.2.2)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus 2.2.0(fpc 3.2.2)-Win64,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6302 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7805(7807)
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.0.0(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.2.0(fpc 3.2.2)-Win32,
- Lazarus 2.2.2(fpc 3.2.2)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus 2.2.0(fpc 3.2.2)-Win64,
- Lazarus 2.2.2(fpc 3.2.2)-Win64,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6367 PerfTest passes(Delphi 11.1 Alexandria, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7814)
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.2(fpc 3.2.2)-Win32,
- Delphi 2007(-ZBase64.pas),
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6382 PerfTest passes(Delphi 11.1 Alexandria, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847

Michał

[miab3]

ZEOS 8.0.0 /patches svn 7826)
https://sourceforge.net/p/zeoslib/code- ... 0-patches/

Compiles and Works:

- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus 2.2.2(fpc 3.2.2)-Win32,
- Delphi 2007(-ZBase64.pas),
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6382 PerfTest passes( Delphi 11.1 Alexandria, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Warning: [DCC Warning] ZDbcProxyResultSet.pas(1107): W1058 Implicit string cast with potential data loss from 'string' to 'AnsiString'
Line1107: Result := ZDecodeBase64(Val);

Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847
and ZMemTable and FreeTDS
viewtopic.php?f=50&t=148059&start=120#p206706

Michał

[marsupilami]

Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847
and ZMemTable and FreeTDS
viewtopic.php?f=50&t=148059&start=120#p206706

Hello Michal, I created two tickets for this. I just need the time to debug this. I assume each of these peoblems will take a minimum of 4 to 8 hours to fix...
See:
https://sourceforge.net/p/zeoslib/tickets/552/
https://sourceforge.net/p/zeoslib/tickets/553/

[miab3]

ZEOS 8.0.0 /trunk svn 7849
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus 2.2.2(fpc 3.2.2)-Win32,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6382 PerfTest passes(Delphi 11.1 Alexandria, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

Hi Jan,

Zeos8trunk svn7870 Delphi 11.1 compiles Win32/Win64/Android/Android64.

But these are two little things:
[dcc32 Hint] ZDbcFirebirdStatement.pas(604): H2164 Variable 'ImmediatelyReleasable' is declared but never used in 'TZAbstractFirebirdStatement.ReleaseImmediat'
[dcc32 Warning] ZDbcProxyResultSet.pas(1107): W1058 Implicit string cast with potential data loss from 'string' to 'AnsiString'

Regards,
Michal

[miab3]

ZEOS 8.0.0 /trunk svn 7891
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.4(fpc 3.2.2)-Win32,
- Delphi 2007(-ZBase64.pas),
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6382 PerfTest passes(Delphi 11.1 Alexandria Win32/Win64, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7911
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.4(fpc 3.2.2)-Win32,
- Delphi 2007(-ZBase64.pas),
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6382 PerfTest passes(Delphi 11.1 Alexandria Win32/Win64, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7936
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.4(fpc 3.2.2)-Win32,
- Delphi 2007(-ZBase64.pas),
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6382 PerfTest passes(Delphi 11.1 Alexandria Win32/Win64, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Code: Select all

Running tests using Synopse mORMot framework 1.18.6382, compiled with Delphi 10.3 Rio 32 bit, against SQLite 3.38.2, at 2022-11-26 14:12:04.

Insertion speed
 	Direct	Batch	Trans	Batch Trans
SQLite3 (file full)	77	3426	46387	110756
SQLite3 (file off)	1010	48944	56518	170992
SQLite3 (file off exc)	16320	149862	57165	174812
SQLite3 (mem)	46920	184372	57534	183952
ZEOS SQlite3	81	2310	45943	98152
ZEOS SQlite3 (ext full)	80	2270	47533	94772
ZEOS SQlite3 (ext off)	994	25495	56229	141067
ZEOS SQlite3 (ext off exc)	21363	127749	56780	146438
ZEOS SQlite3 (mem)	31002	142861	57257	154244
FireDAC SQlite3	12319	20464	33849	112742
UniDAC SQlite3	9078	20027	15181	38560
ODBC MSSQL2012	1031	15469	2407	21152
UniDAC MSSQL2012	1332	3547	2413	3604
ZEOS ODBC_W MSSQL2012	1985	6419	2597	38670
ZEOS ODBC_A MSSQL2012	1827	6080	2543	46951
ZEOS OleDB MSSQL2012	1902	6643	2418	53751
ZEOS Firebird	6066	49540	23037	50337
FireDAC Firebird	2819	51066	17633	51174
Oracle	955	83916	2392	83788
ZEOS Oracle	1150	67861	2682	71359
UniDAC Oracle	922	2393	1545	2479
ZEOS PostgreSQL	1195	59555	2374	61180
FireDAC PostgreSQL	1129	19925	2292	19031
UniDAC PostgreSQL	1030	13226	2549	15131
ZEOS MySQL	2224	20941	2545	40967
FireDAC MySQL	1273	19434	1264	18843
UniDAC MySQL	2388	19986	2482	18464

Read speed
 	By one	All Virtual	All Direct
SQLite3 (file full)	13112	368296	372995
SQLite3 (file off)	13188	363108	365523
SQLite3 (file off exc)	59357	375009	373412
SQLite3 (mem)	59415	376307	375629
ZEOS SQlite3	12640	191783	348456
ZEOS SQlite3 (ext full)	12174	196610	364006
ZEOS SQlite3 (ext off)	12220	194901	350803
ZEOS SQlite3 (ext off exc)	48040	197722	355694
ZEOS SQlite3 (mem)	50094	198255	360023
FireDAC SQlite3	5448	81811	115912
UniDAC SQlite3	5772	74159	102997
ODBC MSSQL2012	2437	100248	183540
UniDAC MSSQL2012	1763	99180	154923
ZEOS ODBC_W MSSQL2012	1204	146528	219327
ZEOS ODBC_A MSSQL2012	1305	149862	209135
ZEOS OleDB MSSQL2012	2407	175691	297548
ZEOS Firebird	23627	88163	126617
FireDAC Firebird	1790	60219	75446
Oracle	3043	122428	174282
ZEOS Oracle	3267	109911	155000
UniDAC Oracle	984	45457	50479
ZEOS PostgreSQL	2855	124700	193543
FireDAC PostgreSQL	542	39841	45671
UniDAC PostgreSQL	343	69387	97814
ZEOS MySQL	2473	124906	196132
FireDAC MySQL	1061	67459	80200
UniDAC MySQL	1761	86997	127042

Michał

[aehimself]

Compiles just fine with 11.3 Alexandria.
Basic stuff (establishing a connection, executing SELECT queries) also successful on MySQL, MSSQL and Oracle.

[miab3]

ZEOS 8.0.0 /trunk svn 7972
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.6-Win32/Win64,
- Delphi 2007,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6435 PerfTest passes(Delphi 11.1 Alexandria Win32/Win64, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal

[miab3]

ZEOS 8.0.0 /trunk svn 7980
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.0-Win32,
- Lazarus 2.2.4-Win64,
- Lazarus 2.2.6-Win32/Win64,
- Delphi 7,
- Delphi 2007,
- Delphi XE2-Win32/Win64,
- Delphi 10-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6435 PerfTest passes(Delphi 11.1 Alexandria Win32/Win64, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal

[miab3]

ZEOS 8.0.0 /trunk svn 7994
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.6-Win32/Win64,
- Delphi 2007,
- Delphi XE2-Win32/Win64,
- Delphi 10-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6435 PerfTest passes(Delphi 11.1 Alexandria Win32/Win64, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal

[miab3]

ZEOS 8.0.0 /trunk svn 8005
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.6-Win32/Win64,
- Delphi D2006,
- Delphi D2007,
- Delphi XE2-Win32/Win64,
- Delphi 10-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11.1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6435 PerfTest passes(Delphi 11.1 Alexandria Win32/Win64, Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal