7.2 testers-thread
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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).
Michal
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"
}
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
Re: 7.2-alfa testers-thread
@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..
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..
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
Re: 7.2-alfa testers-thread
@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
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
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
Re: 7.2-alfa testers-thread
@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.
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.
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
Re: 7.2-alfa testers-thread
@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
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).
Michal
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
Similarly for meEgonHugeist 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.
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"
}
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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).
In Test15-mORMot ZEOS 7.2-alpha branches_ testing_r3281 is usually faster than the alternative libraries.
Michal
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"
}
Michal
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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: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
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}
Congratulates Michael !!!
Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086
Michal