7.2 testers-thread

miab3 · Post by **miab3** » 11.07.2014, 21:58

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3210:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90(Today's 2014.07.11 version) rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Some minor bugs:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

miab3 · Post by **miab3** » 12.07.2014, 11:24

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3215:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90 NEW!!!),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Some minor bugs:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

miab3 · Post by **miab3** » 13.07.2014, 19:05

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3227:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Some minor bugs:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

miab3 · Post by **miab3** » 18.07.2014, 11:57

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3231:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Unidirectional in TZReadOnlyQuery works !!!

Some minor bugs:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

miab3 · Post by **miab3** » 19.07.2014, 09:49

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3232:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Some minor bugs:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

miab3 · Post by **miab3** » 02.08.2014, 19:15

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3241 EDIT:(and r3245):
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Some minor bugs:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

miab3 · Post by **miab3** » 11.08.2014, 14:29

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_r3255:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

mORMot 15 - External DB performance(mod)
http://synopse.info/fossil/info/cde30e2 ... ed6b721cb1
Running tests using Synopse mORMot framework 1.18, compiled with Delphi XE2-32, Firebird 2.5.3(localhost), Oracle XE 11.2g(remote).

Code: Select all

{
	"Engine": "ZEOS Firebird",
	"CreateTableTime": "71.81ms",
	"NumberOfElements": 5000,
	"InsertTime": "3.09s",
	"InsertRate": 1616,
	"InsertBatchTime": "3.04s",
	"InsertBatchRate": 1639,
	"InsertTransactionTime": "264.93ms",
	"InsertTransactionRate": 18872,
	"InsertBatchTransactionTime": "246.44ms",
	"InsertBatchTransactionRate": 20288,
	"ReadOneByOneTime": "377.44ms",
	"ReadOneByOneRate": 13247,
	"ReadAllVirtualTime": "40.56ms",
	"ReadAllVirtualRate": 123262,
	"ReadAllDirectTime": "28.00ms",
	"ReadAllDirectRate": 178514,
	"ClientCloseTime": "4.36ms"
}
{
	"Engine": "AnyDAC Firebird",
	"CreateTableTime": "51.50ms",
	"NumberOfElements": 5000,
	"InsertTime": "255.68ms",
	"InsertRate": 19555,
	"InsertBatchTime": "99.17ms",
	"InsertBatchRate": 50416,
	"InsertTransactionTime": "246.25ms",
	"InsertTransactionRate": 20304,
	"InsertBatchTransactionTime": "97.62ms",
	"InsertBatchTransactionRate": 51214,
	"ReadOneByOneTime": "3.83s",
	"ReadOneByOneRate": 1304,
	"ReadAllVirtualTime": "75.14ms",
	"ReadAllVirtualRate": 66540,
	"ReadAllDirectTime": "57.43ms",
	"ReadAllDirectRate": 87050,
	"ClientCloseTime": "4.42ms"
}
{
	"Engine": "UniDAC Firebird",
	"CreateTableTime": "57.36ms",
	"NumberOfElements": 5000,
	"InsertTime": "3.19s",
	"InsertRate": 1566,
	"InsertBatchTime": "319.96ms",
	"InsertBatchRate": 15626,
	"InsertTransactionTime": "2.95s",
	"InsertTransactionRate": 1691,
	"InsertBatchTransactionTime": "320.37ms",
	"InsertBatchTransactionRate": 15606,
	"ReadOneByOneTime": "2.71s",
	"ReadOneByOneRate": 1839,
	"ReadAllVirtualTime": "55.60ms",
	"ReadAllVirtualRate": 89921,
	"ReadAllDirectTime": "39.81ms",
	"ReadAllDirectRate": 125583,
	"ClientCloseTime": "5.13ms"
}
{
	"Engine": "Oracle",
	"CreateTableTime": "161.85ms",
	"NumberOfElements": 5000,
	"InsertTime": "5.04s",
	"InsertRate": 990,
	"InsertBatchTime": "67.72ms",
	"InsertBatchRate": 73825,
	"InsertTransactionTime": "2.06s",
	"InsertTransactionRate": 2422,
	"InsertBatchTransactionTime": "66.62ms",
	"InsertBatchTransactionRate": 75044,
	"ReadOneByOneTime": "1.92s",
	"ReadOneByOneRate": 2594,
	"ReadAllVirtualTime": "39.70ms",
	"ReadAllVirtualRate": 125931,
	"ReadAllDirectTime": "28.02ms",
	"ReadAllDirectRate": 178405,
	"ClientCloseTime": "42.03ms"
}
{
	"Engine": "AnyDAC Oracle",
	"CreateTableTime": "87.82ms",
	"NumberOfElements": 5000,
	"InsertTime": "5.13s",
	"InsertRate": 973,
	"InsertBatchTime": "86.48ms",
	"InsertBatchRate": 57812,
	"InsertTransactionTime": "1.99s",
	"InsertTransactionRate": 2505,
	"InsertBatchTransactionTime": "84.20ms",
	"InsertBatchTransactionRate": 59380,
	"ReadOneByOneTime": "2.67s",
	"ReadOneByOneRate": 1867,
	"ReadAllVirtualTime": "95.97ms",
	"ReadAllVirtualRate": 52095,
	"ReadAllDirectTime": "77.48ms",
	"ReadAllDirectRate": 64526,
	"ClientCloseTime": "98.91ms"
}
{
	"Engine": "ZEOS Oracle",
	"CreateTableTime": "72.68ms",
	"NumberOfElements": 5000,
	"InsertTime": "4.85s",
	"InsertRate": 1030,
	"InsertBatchTime": "806.80ms",
	"InsertBatchRate": 6197,
	"InsertTransactionTime": "2.01s",
	"InsertTransactionRate": 2481,
	"InsertBatchTransactionTime": "763.64ms",
	"InsertBatchTransactionRate": 6547,
	"ReadOneByOneTime": "1.92s",
	"ReadOneByOneRate": 2598,
	"ReadAllVirtualTime": "41.62ms",
	"ReadAllVirtualRate": 120120,
	"ReadAllDirectTime": "33.00ms",
	"ReadAllDirectRate": 151496,
	"ClientCloseTime": "34.76ms"
}

Michal

Post by **EgonHugeist** » 15.08.2014, 19:27

@miab3

just a hint about the huge Orecle insertation performance diffs: http://synopse.info/forum/viewtopic.php?id=1508&p=2

For FB the synopse insertion test's behave equal..

miab3 · Post by **miab3** » 17.08.2014, 20:13

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_r3263:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

Post by **EgonHugeist** » 20.08.2014, 10:47

@Miab3

Michal, finally i did inform synopse about current refactoring: http://synopse.info/forum/viewtopic.php?id=1508&p=2

So our bechmarks for 7.2 + Oracle do look pretty nice now.

miab3 · Post by **miab3** » 20.08.2014, 12:14

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_r3267:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

EgonHugeist wrote:@Miab3
Michal, finally i did inform synopse about current refactoring: http://synopse.info/forum/viewtopic.php?id=1508&p=2

So our bechmarks for 7.2 + Oracle do look pretty nice now.

Similarly for me

mORMot 15 - External DB performance(mod)
http://synopse.info/fossil/info/c37e779 ... ca73d1307b
Running tests using Synopse mORMot framework 1.18, compiled with Delphi XE2, at 2014-08-20 12:11:52.
Firebird 2.5.3(localhost), Oracle XE 11.2g(remote), MySQL 5.5.35(localhost).

Code: Select all

{
	"Engine": "ZEOS Firebird",
	"CreateTableTime": "69.86ms",
	"NumberOfElements": 5000,
	"InsertTime": "3.14s",
	"InsertRate": 1589,
	"InsertBatchTime": "3.04s",
	"InsertBatchRate": 1643,
	"InsertTransactionTime": "265.14ms",
	"InsertTransactionRate": 18857,
	"InsertBatchTransactionTime": "247.88ms",
	"InsertBatchTransactionRate": 20170,
	"ReadOneByOneTime": "367.69ms",
	"ReadOneByOneRate": 13598,
	"ReadAllVirtualTime": "39.64ms",
	"ReadAllVirtualRate": 126128,
	"ReadAllDirectTime": "29.43ms",
	"ReadAllDirectRate": 169842,
	"ClientCloseTime": "4.35ms"
}
{
	"Engine": "AnyDAC Firebird",
	"CreateTableTime": "71.33ms",
	"NumberOfElements": 5000,
	"InsertTime": "245.63ms",
	"InsertRate": 20355,
	"InsertBatchTime": "99.77ms",
	"InsertBatchRate": 50112,
	"InsertTransactionTime": "245.45ms",
	"InsertTransactionRate": 20370,
	"InsertBatchTransactionTime": "97.74ms",
	"InsertBatchTransactionRate": 51155,
	"ReadOneByOneTime": "4.27s",
	"ReadOneByOneRate": 1169,
	"ReadAllVirtualTime": "75.04ms",
	"ReadAllVirtualRate": 66623,
	"ReadAllDirectTime": "57.55ms",
	"ReadAllDirectRate": 86873,
	"ClientCloseTime": "4.70ms"
}
{
	"Engine": "UniDAC Firebird",
	"CreateTableTime": "77.79ms",
	"NumberOfElements": 5000,
	"InsertTime": "4.23s",
	"InsertRate": 1179,
	"InsertBatchTime": "316.47ms",
	"InsertBatchRate": 15798,
	"InsertTransactionTime": "3.72s",
	"InsertTransactionRate": 1343,
	"InsertBatchTransactionTime": "317.05ms",
	"InsertBatchTransactionRate": 15770,
	"ReadOneByOneTime": "2.74s",
	"ReadOneByOneRate": 1819,
	"ReadAllVirtualTime": "55.72ms",
	"ReadAllVirtualRate": 89726,
	"ReadAllDirectTime": "40.29ms",
	"ReadAllDirectRate": 124081,
	"ClientCloseTime": "4.32ms"
}
{
	"Engine": "Oracle",
	"CreateTableTime": "179.32ms",
	"NumberOfElements": 5000,
	"InsertTime": "5.00s",
	"InsertRate": 998,
	"InsertBatchTime": "67.05ms",
	"InsertBatchRate": 74570,
	"InsertTransactionTime": "2.13s",
	"InsertTransactionRate": 2341,
	"InsertBatchTransactionTime": "68.87ms",
	"InsertBatchTransactionRate": 72591,
	"ReadOneByOneTime": "1.91s",
	"ReadOneByOneRate": 2605,
	"ReadAllVirtualTime": "40.24ms",
	"ReadAllVirtualRate": 124254,
	"ReadAllDirectTime": "28.76ms",
	"ReadAllDirectRate": 173846,
	"ClientCloseTime": "34.24ms"
}
{
	"Engine": "ZEOS Oracle",
	"CreateTableTime": "174.00ms",
	"NumberOfElements": 5000,
	"InsertTime": "4.97s",
	"InsertRate": 1004,
	"InsertBatchTime": "78.58ms",
	"InsertBatchRate": 63623,
	"InsertTransactionTime": "1.99s",
	"InsertTransactionRate": 2503,
	"InsertBatchTransactionTime": "77.52ms",
	"InsertBatchTransactionRate": 64494,
	"ReadOneByOneTime": "1.92s",
	"ReadOneByOneRate": 2601,
	"ReadAllVirtualTime": "40.06ms",
	"ReadAllVirtualRate": 124809,
	"ReadAllDirectTime": "30.71ms",
	"ReadAllDirectRate": 162771,
	"ClientCloseTime": "98.68ms"
}
{
	"Engine": "AnyDAC Oracle",
	"CreateTableTime": "102.03ms",
	"NumberOfElements": 5000,
	"InsertTime": "4.78s",
	"InsertRate": 1044,
	"InsertBatchTime": "87.73ms",
	"InsertBatchRate": 56991,
	"InsertTransactionTime": "1.99s",
	"InsertTransactionRate": 2510,
	"InsertBatchTransactionTime": "86.04ms",
	"InsertBatchTransactionRate": 58110,
	"ReadOneByOneTime": "2.66s",
	"ReadOneByOneRate": 1877,
	"ReadAllVirtualTime": "94.28ms",
	"ReadAllVirtualRate": 53033,
	"ReadAllDirectTime": "75.40ms",
	"ReadAllDirectRate": 66305,
	"ClientCloseTime": "39.05ms"
}
{
	"Engine": "UniDAC Oracle",
	"CreateTableTime": "150.56ms",
	"NumberOfElements": 5000,
	"InsertTime": "5.23s",
	"InsertRate": 955,
	"InsertBatchTime": "1.05s",
	"InsertBatchRate": 4738,
	"InsertTransactionTime": "2.62s",
	"InsertTransactionRate": 1902,
	"InsertBatchTransactionTime": "1.00s",
	"InsertBatchTransactionRate": 4992,
	"ReadOneByOneTime": "4.90s",
	"ReadOneByOneRate": 1018,
	"ReadAllVirtualTime": "123.67ms",
	"ReadAllVirtualRate": 40427,
	"ReadAllDirectTime": "109.83ms",
	"ReadAllDirectRate": 45524,
	"ClientCloseTime": "54.09ms"
}
{
	"Engine": "ZEOS MySQL",
	"CreateTableTime": "96.19ms",
	"NumberOfElements": 5000,
	"InsertTime": "488.83ms",
	"InsertRate": 10228,
	"InsertBatchTime": "127.18ms",
	"InsertBatchRate": 39313,
	"InsertTransactionTime": "402.10ms",
	"InsertTransactionRate": 12434,
	"InsertBatchTransactionTime": "116.95ms",
	"InsertBatchTransactionRate": 42750,
	"ReadOneByOneTime": "3.70s",
	"ReadOneByOneRate": 1350,
	"ReadAllVirtualTime": "29.75ms",
	"ReadAllVirtualRate": 168055,
	"ReadAllDirectTime": "21.27ms",
	"ReadAllDirectRate": 235039,
	"ClientCloseTime": "50.46ms"
}
{
	"Engine": "AnyDAC MySQL",
	"CreateTableTime": "1.08s",
	"NumberOfElements": 5000,
	"InsertTime": "764.51ms",
	"InsertRate": 6540,
	"InsertBatchTime": "120.99ms",
	"InsertBatchRate": 41324,
	"InsertTransactionTime": "474.95ms",
	"InsertTransactionRate": 10527,
	"InsertBatchTransactionTime": "111.16ms",
	"InsertBatchTransactionRate": 44979,
	"ReadOneByOneTime": "1.33s",
	"ReadOneByOneRate": 3756,
	"ReadAllVirtualTime": "53.77ms",
	"ReadAllVirtualRate": 92988,
	"ReadAllDirectTime": "37.87ms",
	"ReadAllDirectRate": 132006,
	"ClientCloseTime": "38.07ms"
}
{
	"Engine": "UniDAC MySQL",
	"CreateTableTime": "111.66ms",
	"NumberOfElements": 5000,
	"InsertTime": "584.19ms",
	"InsertRate": 8558,
	"InsertBatchTime": "178.21ms",
	"InsertBatchRate": 28055,
	"InsertTransactionTime": "416.87ms",
	"InsertTransactionRate": 11993,
	"InsertBatchTransactionTime": "167.59ms",
	"InsertBatchTransactionRate": 29834,
	"ReadOneByOneTime": "953.97ms",
	"ReadOneByOneRate": 5241,
	"ReadAllVirtualTime": "40.86ms",
	"ReadAllVirtualRate": 122351,
	"ReadAllDirectTime": "26.07ms",
	"ReadAllDirectRate": 191783,
	"ClientCloseTime": "32.01ms"
}

Michal

miab3 · Post by **miab3** » 21.08.2014, 13:45

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_r3270:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90)

CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

mORMot 15 - External DB performance(mod) from:
http://synopse.info/fossil/info/bcdb08c ... 204e7c9a34
works

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

miab3 · Post by **miab3** » 25.08.2014, 12:21

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_r3281:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

mORMot 15 - External DB performance(mod)
http://synopse.info/fossil/info/c170d26 ... 9f55cda2c7
Running tests using Synopse mORMot framework 1.18, compiled with Delphi XE2-32.
C2D; 2GHz/4GB RAM; Windows 8.1-64
Firebird 2.5.3(localhost), Oracle XE 11.2g(localhost), PostgreSQL 9.3.0(localhost), MariaDB 5.5.35(localhost).

Code: Select all

{
  "Engine": "ZEOS Firebird",
  "CreateTableTime": "195.44ms",
  "NumberOfElements": 5000,
  "InsertTime": "1.83s",
  "InsertRate": 2731,
  "InsertBatchTime": "194.90ms",
  "InsertBatchRate": 25653,
  "InsertTransactionTime": "807.83ms",
  "InsertTransactionRate": 6189,
  "InsertBatchTransactionTime": "195.24ms",
  "InsertBatchTransactionRate": 25609,
  "ReadOneByOneTime": "1.00s",
  "ReadOneByOneRate": 4976,
  "ReadAllVirtualTime": "78.84ms",
  "ReadAllVirtualRate": 63415,
  "ReadAllDirectTime": "56.95ms",
  "ReadAllDirectRate": 87782,
  "ClientCloseTime": "19.82ms"
}
{
  "Engine": "AnyDAC Firebird",
  "CreateTableTime": "116.37ms",
  "NumberOfElements": 5000,
  "InsertTime": "561.83ms",
  "InsertRate": 8899,
  "InsertBatchTime": "221.78ms",
  "InsertBatchRate": 22544,
  "InsertTransactionTime": "631.11ms",
  "InsertTransactionRate": 7922,
  "InsertBatchTransactionTime": "217.97ms",
  "InsertBatchTransactionRate": 22938,
  "ReadOneByOneTime": "5.43s",
  "ReadOneByOneRate": 920,
  "ReadAllVirtualTime": "158.16ms",
  "ReadAllVirtualRate": 31611,
  "ReadAllDirectTime": "124.49ms",
  "ReadAllDirectRate": 40161,
  "ClientCloseTime": "11.73ms"
}
{
  "Engine": "UniDAC Firebird",
  "CreateTableTime": "115.34ms",
  "NumberOfElements": 5000,
  "InsertTime": "2.92s",
  "InsertRate": 1706,
  "InsertBatchTime": "723.14ms",
  "InsertBatchRate": 6914,
  "InsertTransactionTime": "3.03s",
  "InsertTransactionRate": 1645,
  "InsertBatchTransactionTime": "757.81ms",
  "InsertBatchTransactionRate": 6597,
  "ReadOneByOneTime": "5.75s",
  "ReadOneByOneRate": 869,
  "ReadAllVirtualTime": "110.12ms",
  "ReadAllVirtualRate": 45405,
  "ReadAllDirectTime": "80.69ms",
  "ReadAllDirectRate": 61958,
  "ClientCloseTime": "20.15ms"
}
{
  "Engine": "Oracle",
  "CreateTableTime": "1.81s",
  "NumberOfElements": 5000,
  "InsertTime": "3.79s",
  "InsertRate": 1316,
  "InsertBatchTime": "93.67ms",
  "InsertBatchRate": 53376,
  "InsertTransactionTime": "1.45s",
  "InsertTransactionRate": 3429,
  "InsertBatchTransactionTime": "102.08ms",
  "InsertBatchTransactionRate": 48977,
  "ReadOneByOneTime": "1.08s",
  "ReadOneByOneRate": 4617,
  "ReadAllVirtualTime": "60.44ms",
  "ReadAllVirtualRate": 82723,
  "ReadAllDirectTime": "38.76ms",
  "ReadAllDirectRate": 128995,
  "ClientCloseTime": "106.46ms"
}
{
  "Engine": "ZEOS Oracle",
  "CreateTableTime": "415.43ms",
  "NumberOfElements": 5000,
  "InsertTime": "3.88s",
  "InsertRate": 1286,
  "InsertBatchTime": "186.80ms",
  "InsertBatchRate": 26766,
  "InsertTransactionTime": "1.52s",
  "InsertTransactionRate": 3281,
  "InsertBatchTransactionTime": "145.87ms",
  "InsertBatchTransactionRate": 34274,
  "ReadOneByOneTime": "1.05s",
  "ReadOneByOneRate": 4752,
  "ReadAllVirtualTime": "60.85ms",
  "ReadAllVirtualRate": 82169,
  "ReadAllDirectTime": "44.71ms",
  "ReadAllDirectRate": 111826,
  "ClientCloseTime": "37.13ms"
}
{
  "Engine": "AnyDAC Oracle",
  "CreateTableTime": "718.57ms",
  "NumberOfElements": 5000,
  "InsertTime": "4.19s",
  "InsertRate": 1191,
  "InsertBatchTime": "177.05ms",
  "InsertBatchRate": 28240,
  "InsertTransactionTime": "1.35s",
  "InsertTransactionRate": 3689,
  "InsertBatchTransactionTime": "146.70ms",
  "InsertBatchTransactionRate": 34081,
  "ReadOneByOneTime": "2.37s",
  "ReadOneByOneRate": 2103,
  "ReadAllVirtualTime": "116.94ms",
  "ReadAllVirtualRate": 42754,
  "ReadAllDirectTime": "85.39ms",
  "ReadAllDirectRate": 58554,
  "ClientCloseTime": "39.82ms"
}
{
  "Engine": "UniDAC Oracle",
  "CreateTableTime": "295.75ms",
  "NumberOfElements": 5000,
  "InsertTime": "4.68s",
  "InsertRate": 1067,
  "InsertBatchTime": "1.39s",
  "InsertBatchRate": 3587,
  "InsertTransactionTime": "1.97s",
  "InsertTransactionRate": 2526,
  "InsertBatchTransactionTime": "1.41s",
  "InsertBatchTransactionRate": 3533,
  "ReadOneByOneTime": "3.30s",
  "ReadOneByOneRate": 1512,
  "ReadAllVirtualTime": "118.55ms",
  "ReadAllVirtualRate": 42175,
  "ReadAllDirectTime": "89.28ms",
  "ReadAllDirectRate": 55998,
  "ClientCloseTime": "44.87ms"
}
{
  "Engine": "ZEOS PostgreSQL",
  "CreateTableTime": "225.60ms",
  "NumberOfElements": 5000,
  "InsertTime": "2.91s",
  "InsertRate": 1717,
  "InsertBatchTime": "301.73ms",
  "InsertBatchRate": 16571,
  "InsertTransactionTime": "986.70ms",
  "InsertTransactionRate": 5067,
  "InsertBatchTransactionTime": "247.36ms",
  "InsertBatchTransactionRate": 20213,
  "ReadOneByOneTime": "1.04s",
  "ReadOneByOneRate": 4775,
  "ReadAllVirtualTime": "76.36ms",
  "ReadAllVirtualRate": 65475,
  "ReadAllDirectTime": "51.59ms",
  "ReadAllDirectRate": 96918,
  "ClientCloseTime": "26.17ms"
}
{
  "Engine": "AnyDAC PostgreSQL",
  "CreateTableTime": "81.29ms",
  "NumberOfElements": 5000,
  "InsertTime": "2.99s",
  "InsertRate": 1667,
  "InsertBatchTime": "355.76ms",
  "InsertBatchRate": 14054,
  "InsertTransactionTime": "987.09ms",
  "InsertTransactionRate": 5065,
  "InsertBatchTransactionTime": "352.21ms",
  "InsertBatchTransactionRate": 14195,
  "ReadOneByOneTime": "4.16s",
  "ReadOneByOneRate": 1201,
  "ReadAllVirtualTime": "145.23ms",
  "ReadAllVirtualRate": 34426,
  "ReadAllDirectTime": "110.92ms",
  "ReadAllDirectRate": 45074,
  "ClientCloseTime": "29.53ms"
}
{
  "Engine": "UniDAC PostgreSQL",
  "CreateTableTime": "82.61ms",
  "NumberOfElements": 5000,
  "InsertTime": "4.08s",
  "InsertRate": 1223,
  "InsertBatchTime": "471.86ms",
  "InsertBatchRate": 10596,
  "InsertTransactionTime": "2.17s",
  "InsertTransactionRate": 2299,
  "InsertBatchTransactionTime": "420.89ms",
  "InsertBatchTransactionRate": 11879,
  "ReadOneByOneTime": "11.10s",
  "ReadOneByOneRate": 450,
  "ReadAllVirtualTime": "123.22ms",
  "ReadAllVirtualRate": 40576,
  "ReadAllDirectTime": "84.65ms",
  "ReadAllDirectRate": 59061,
  "ClientCloseTime": "35.91ms"
}
{
  "Engine": "ZEOS MySQL",
  "CreateTableTime": "71.91ms",
  "NumberOfElements": 5000,
  "InsertTime": "4.84s",
  "InsertRate": 1031,
  "InsertBatchTime": "374.22ms",
  "InsertBatchRate": 13360,
  "InsertTransactionTime": "844.48ms",
  "InsertTransactionRate": 5920,
  "InsertBatchTransactionTime": "258.85ms",
  "InsertBatchTransactionRate": 19315,
  "ReadOneByOneTime": "8.16s",
  "ReadOneByOneRate": 612,
  "ReadAllVirtualTime": "56.45ms",
  "ReadAllVirtualRate": 88566,
  "ReadAllDirectTime": "41.69ms",
  "ReadAllDirectRate": 119924,
  "ClientCloseTime": "18.62ms"
}
{
  "Engine": "AnyDAC MySQL",
  "CreateTableTime": "44.68ms",
  "NumberOfElements": 5000,
  "InsertTime": "4.91s",
  "InsertRate": 1018,
  "InsertBatchTime": "245.86ms",
  "InsertBatchRate": 20336,
  "InsertTransactionTime": "1.08s",
  "InsertTransactionRate": 4618,
  "InsertBatchTransactionTime": "243.61ms",
  "InsertBatchTransactionRate": 20523,
  "ReadOneByOneTime": "2.56s",
  "ReadOneByOneRate": 1950,
  "ReadAllVirtualTime": "113.78ms",
  "ReadAllVirtualRate": 43942,
  "ReadAllDirectTime": "80.40ms",
  "ReadAllDirectRate": 62182,
  "ClientCloseTime": "32.82ms"
}
{
  "Engine": "UniDAC MySQL",
  "CreateTableTime": "38.11ms",
  "NumberOfElements": 5000,
  "InsertTime": "4.90s",
  "InsertRate": 1018,
  "InsertBatchTime": "394.30ms",
  "InsertBatchRate": 12680,
  "InsertTransactionTime": "915.46ms",
  "InsertTransactionRate": 5461,
  "InsertBatchTransactionTime": "343.25ms",
  "InsertBatchTransactionRate": 14566,
  "ReadOneByOneTime": "2.06s",
  "ReadOneByOneRate": 2424,
  "ReadAllVirtualTime": "78.59ms",
  "ReadAllVirtualRate": 63615,
  "ReadAllDirectTime": "52.82ms",
  "ReadAllDirectRate": 94648,
  "ClientCloseTime": "13.90ms"
}

In Test15-mORMot ZEOS 7.2-alpha branches_ testing_r3281 is usually faster than the alternative libraries.

Michal

miab3 · Post by **miab3** » 31.08.2014, 23:01

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_r3284:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

miab3 · Post by **miab3** » 06.09.2014, 12:10

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_r3285:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90),
CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

After adding in Zeos.inc:

Code: Select all

// Compilation directives for Delphi XE7
  {$IFDEF VER280}
  {$DEFINE VER200BELOW} // Used in code
  {$DEFINE DELPHI12_UP} // Used in code
  {$DEFINE DELPHI14_UP} //Egonhugeist used in my code
  {$DEFINE DELPHI15_UP} // Used in zeos.inc only
  {$DEFINE DELPHI16_UP} // Used in code
  {$DEFINE DELPHI17_UP} // Used in zeos.inc only
  {$DEFINE DELPHI18_UP} // Used in zeos.inc only
  {$DEFINE DELPHI19_UP} // Used in zeos.inc only
  {$DEFINE DELPHI20_UP} //By dieletro Used in zeos.inc only
  {$DEFINE DELPHI21_UP}
  {$DEFINE BDS4_UP} // Used in code
  {$DEFINE BDS5_UP} // Used in code
{$ENDIF}

and after adjustment packages configuration (suffix 210 and paths), also works with Free trial of Delphi XE7.

Congratulates Michael !!!

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal

Zeoslib Portal

7.2 testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread