7.2 testers-thread

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
Locked
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

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
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
papelhigienico
Expert Boarder
Expert Boarder
Posts: 113
Joined: 06.10.2006, 14:41
Location: Chapecó - Santa Catarina
Contact:
Contact papelhigienico

Re: 7.2-alfa testers-thread

Post by papelhigienico »

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??
Top
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Re: 7.2-alfa testers-thread

Post by EgonHugeist »

@Miab3

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

@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
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/

Image
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
papelhigienico
Expert Boarder
Expert Boarder
Posts: 113
Joined: 06.10.2006, 14:41
Location: Chapecó - Santa Catarina
Contact:
Contact papelhigienico

Re: 7.2-alfa testers-thread

Post by papelhigienico »

@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?
Top
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Re: 7.2-alfa testers-thread

Post by EgonHugeist »

@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! :lol:
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/

Image
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-alfa testers-thread

Post by miab3 »

@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
Top
Locked

Return to “ZeosLib 7.2 Forum”