Zeoslib Portal

Posted: **15.06.2014, 13:50**

@EgonHugeist,

Zeos7.2-alpha branches_ testing_r3154:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/

Mormot Test 15 - External DB performance - works without error (in Oracle) !!!

Code: Select all

{
	"Engine": "Oracle",
	"CreateTableTime": "1.51s",
	"NumberOfElements": 5000,
	"InsertTime": "5.33s",
	"InsertRate": 936,
	"InsertBatchTime": "82.22ms",
	"InsertBatchRate": 60808,
	"InsertTransactionTime": "2.14s",
	"InsertTransactionRate": 2330,
	"InsertBatchTransactionTime": "76.52ms",
	"InsertBatchTransactionRate": 65341,
	"ReadOneByOneTime": "1.92s",
	"ReadOneByOneRate": 2598,
	"ReadAllVirtualTime": "108.80ms",
	"ReadAllVirtualRate": 45953,
	"ReadAllDirectTime": "28.53ms",
	"ReadAllDirectRate": 175223,
	"ClientCloseTime": "50.75ms"
}
{
	"Engine": "AnyDAC Oracle",
	"CreateTableTime": "840.14ms",
	"NumberOfElements": 5000,
	"InsertTime": "5.11s",
	"InsertRate": 977,
	"InsertBatchTime": "137.45ms",
	"InsertBatchRate": 36376,
	"InsertTransactionTime": "2.00s",
	"InsertTransactionRate": 2499,
	"InsertBatchTransactionTime": "86.61ms",
	"InsertBatchTransactionRate": 57730,
	"ReadOneByOneTime": "2.54s",
	"ReadOneByOneRate": 1968,
	"ReadAllVirtualTime": "95.71ms",
	"ReadAllVirtualRate": 52238,
	"ReadAllDirectTime": "73.69ms",
	"ReadAllDirectRate": 67843,
	"ClientCloseTime": "90.59ms"
}
{
	"Engine": "ZEOS Oracle",
	"CreateTableTime": "522.61ms",
	"NumberOfElements": 5000,
	"InsertTime": "5.13s",
	"InsertRate": 974,
	"InsertBatchTime": "805.75ms",
	"InsertBatchRate": 6205,
	"InsertTransactionTime": "2.04s",
	"InsertTransactionRate": 2440,
	"InsertBatchTransactionTime": "733.59ms",
	"InsertBatchTransactionRate": 6815,
	"ReadOneByOneTime": "3.10s",
	"ReadOneByOneRate": 1612,
	"ReadAllVirtualTime": "146.69ms",
	"ReadAllVirtualRate": 34084,
	"ReadAllDirectTime": "137.79ms",
	"ReadAllDirectRate": 36285,
	"ClientCloseTime": "26.65ms"
}

Michal

Posted: **16.06.2014, 10:31**

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3157:
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.80)
CodeTyphon ver 4.80 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.

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

Michal

Posted: **19.06.2014, 11:22**

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3158:
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.80)
CodeTyphon ver 4.80 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.

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

Michal

Posted: **20.06.2014, 17:34**

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3160:
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.80)
CodeTyphon ver 4.80 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.

Significant acceleration of Oracle. Bravo EgonHugeist !!!

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

Michal

Posted: **22.06.2014, 15:26**

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3172:
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.80)
CodeTyphon ver 4.80 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

Posted: **22.06.2014, 15:33**

Zeos7.2-alpha branches_ testing_r3172:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/

Mormot Test 15 - External DB performance
http://synopse.info/fossil/info/c6f33429d0

Code: Select all

{
    "Engine": "ZEOS Firebird",
    "CreateTableTime": "170.12ms",
    "NumberOfElements": 5000,
    "InsertTime": "2.65s",
    "InsertRate": 1885,
    "InsertBatchTime": "3.22s",
    "InsertBatchRate": 1549,
    "InsertTransactionTime": "298.01ms",
    "InsertTransactionRate": 16777,
    "InsertBatchTransactionTime": "273.87ms",
    "InsertBatchTransactionRate": 18256,
    "ReadOneByOneTime": "420.84ms",
    "ReadOneByOneRate": 11880,
    "ReadAllVirtualTime": "38.83ms",
    "ReadAllVirtualRate": 128736,
    "ReadAllDirectTime": "28.70ms",
    "ReadAllDirectRate": 174216,
    "ClientCloseTime": "62us"
}
{
    "Engine": "AnyDAC Firebird",
    "CreateTableTime": "78.00ms",
    "NumberOfElements": 5000,
    "InsertTime": "260.57ms",
    "InsertRate": 19188,
    "InsertBatchTime": "100.15ms",
    "InsertBatchRate": 49923,
    "InsertTransactionTime": "263.20ms",
    "InsertTransactionRate": 18996,
    "InsertBatchTransactionTime": "100.70ms",
    "InsertBatchTransactionRate": 49648,
    "ReadOneByOneTime": "4.34s",
    "ReadOneByOneRate": 1150,
    "ReadAllVirtualTime": "78.41ms",
    "ReadAllVirtualRate": 63763,
    "ReadAllDirectTime": "60.13ms",
    "ReadAllDirectRate": 83142,
    "ClientCloseTime": "61us"
}
{
    "Engine": "UniDAC Firebird",
    "CreateTableTime": "58.71ms",
    "NumberOfElements": 5000,
    "InsertTime": "3.60s",
    "InsertRate": 1388,
    "InsertBatchTime": "329.98ms",
    "InsertBatchRate": 15152,
    "InsertTransactionTime": "3.26s",
    "InsertTransactionRate": 1532,
    "InsertBatchTransactionTime": "331.43ms",
    "InsertBatchTransactionRate": 15086,
    "ReadOneByOneTime": "3.04s",
    "ReadOneByOneRate": 1639,
    "ReadAllVirtualTime": "56.11ms",
    "ReadAllVirtualRate": 89104,
    "ReadAllDirectTime": "40.68ms",
    "ReadAllDirectRate": 122898,
    "ClientCloseTime": "41us"
}
{
    "Engine": "Oracle",
    "CreateTableTime": "452.42ms",
    "NumberOfElements": 5000,
    "InsertTime": "4.97s",
    "InsertRate": 1005,
    "InsertBatchTime": "67.02ms",
    "InsertBatchRate": 74603,
    "InsertTransactionTime": "2.01s",
    "InsertTransactionRate": 2481,
    "InsertBatchTransactionTime": "66.09ms",
    "InsertBatchTransactionRate": 75650,
    "ReadOneByOneTime": "2.04s",
    "ReadOneByOneRate": 2444,
    "ReadAllVirtualTime": "40.96ms",
    "ReadAllVirtualRate": 122049,
    "ReadAllDirectTime": "27.78ms",
    "ReadAllDirectRate": 179959,
    "ClientCloseTime": "84.72ms"
}
{
    "Engine": "AnyDAC Oracle",
    "CreateTableTime": "139.69ms",
    "NumberOfElements": 5000,
    "InsertTime": "4.86s",
    "InsertRate": 1028,
    "InsertBatchTime": "86.57ms",
    "InsertBatchRate": 57754,
    "InsertTransactionTime": "1.97s",
    "InsertTransactionRate": 2537,
    "InsertBatchTransactionTime": "86.57ms",
    "InsertBatchTransactionRate": 57752,
    "ReadOneByOneTime": "2.24s",
    "ReadOneByOneRate": 2225,
    "ReadAllVirtualTime": "93.33ms",
    "ReadAllVirtualRate": 53571,
    "ReadAllDirectTime": "70.86ms",
    "ReadAllDirectRate": 70552,
    "ClientCloseTime": "26.51ms"
}
{
    "Engine": "ZEOS Oracle",
    "CreateTableTime": "457.06ms",
    "NumberOfElements": 5000,
    "InsertTime": "5.16s",
    "InsertRate": 967,
    "InsertBatchTime": "771.24ms",
    "InsertBatchRate": 6482,
    "InsertTransactionTime": "2.01s",
    "InsertTransactionRate": 2478,
    "InsertBatchTransactionTime": "738.18ms",
    "InsertBatchTransactionRate": 6773,
    "ReadOneByOneTime": "2.29s",
    "ReadOneByOneRate": 2183,
    "ReadAllVirtualTime": "42.02ms",
    "ReadAllVirtualRate": 118971,
    "ReadAllDirectTime": "33.78ms",
    "ReadAllDirectRate": 147985,
    "ClientCloseTime": "44.58ms"
}

Michal

Posted: **24.06.2014, 17:11**

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3174:
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.80)
CodeTyphon ver 4.80 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

Posted: **25.06.2014, 18:25**

Hi @EgonHugeist !!

Some time ago, I commit a change that make ZeosLib at least compiles on ARM processors (rev. 3104) being reverted by you on rev. 3124. Has something wrong with the changes??

Posted: **27.06.2014, 22:12**

@Miab3

first of all thanks your report and the hints. And of course for the applause

@papelhigienico

I have no ARM CPU to test your suggest patch. First of all your patch did kill some FPC-code extention i made for faster conversion on ZDbcCache.pas(still not complete reverted from my side) and ZFastCode.pas. My impression you did work with deprecated revs.? To avoid again (future patches): Finalize you current work. DO NOT update your SVN-rev while working on. If you're ready: move your changes to your SVN Folder, if your working with different WC's like i'm doing it. Before commit the changes just click SVN->Update. Than all newly commited patches from other devs became merged and you should check compling again. If everything is fine -> Commit. Just a little advice, I know this little :beep: because it happend to me too.. So don't worry about it.

Accordingly the LConEncding thing: I did follow your suggestion. R3177. My main intention for changing your patch: Delphi always did raise a Warning (compare is allways true) and we try to move such directives to the two *.inc files, if possible, of course. -> Warning was resolved
The second part was:

{$IFDEF FPC}
{$IFDEF cpuarm} <- this one
StrLen: function(Str: PChar): sizeint; <- and this one
{$ELSE}
StrLen: function(Str: PAnsiChar): {$IFDEF cpui386}LongInt{$ELSE}Int64{$ENDIF};
{$ENDIF}
{$ELSE}
StrLen: function(const Str: PAnsiChar): Cardinal;
{$ENDIF}

as marked. May i ask what made trouble here? Str: PChar or the Result-Type (SizeInt). If the PChar vs. PAnsiChar made trouble than i'm afraid we will have a broken Zeos for the most plains and cpuarm. Is it a common CPUARM patch or a fix for WinCE? AFAIK is the WinCE compiler Unicode based...

Michael

Posted: **28.06.2014, 10:55**

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3179:
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.80)
CodeTyphon ver 4.80 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

Posted: **30.06.2014, 12:16**

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3188(3190):
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.80)
CodeTyphon ver 4.80 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

Posted: **02.07.2014, 15:33**

@EgonHugeist

Sorry by annoying troubles caused by my changes. You are the most active Zeos developer, so, I can send the ARM patches to you. You agree?

Posted: **04.07.2014, 23:15**

@papelhigienico,

don't worry about it. I absolutely agree. Did you update your current rev? Are you unsing testing-7.2? Same bandwidth? Let's go!

Posted: **05.07.2014, 11:07**

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3203:
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.80),
CodeTyphon ver 4.80 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

Posted: **06.07.2014, 11:41**

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3209:
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.80),
CodeTyphon ver 4.80 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

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