ZeosLib 7.1 testers-thread

[EgonHugeist]

miab3,

i got the little bug! Patch done R2270.
IMHO was it an all time issue. I made a SVN compare and the reported issue was never handled before. Can you confirm my patch?

I didn't touch the array types. Still fighting with the updates for minior String-convertations...

[miab3]

@EgonHugeist,

After R2270 it's fine.

Michal

[miab3]

@EgonHugeist,

Could you change in ZDbcDbLibMetadata.pas:

Code: Select all

+ ' sysobjects o on (o.id = c.id) where o.name = %s and c.number=0 order by colid',

on

Code: Select all

+ ' sysobjects o on (o.id = c.id) where o.name COLLATE Latin1_General_CS_AS = %s and c.number=0 order by colid',

I will not have to constantly fix it.
This is an explanation:
http://blog.sqlauthority.com/2007/04/30 ... ry-search/

Michal

[EgonHugeist]

miab3,

Patch done R2289 \testing7.1 (SVN)

Thank you Michal.

May i ask you if you have some benchmark tests to check a internal speed increase?

[miab3]

@EgonHugeist,

I did not notice a significant difference in the speed of the R2290.

[s]However, recently I noticed a drop in performance ORACLE particular read/update master-detail-subdetail (and i not are able to determine which patch caused it).
(A similar test at Firebird is three times faster than ORACLE).[/s]
I think it the fault of my ORACLE (I'll have to put it all over again).

Michal

[EgonHugeist]

miab3,

that's not what i mean. I'm currently working on the RawUpgrade and do optimize the String convertion routines. Tody i've killed my local working copy of the dbc-layer. Inbetween i'm a little bit frustrated. Well i'll try to merge "save" changes to SVN as good as possible (since i've again over 3000 changes lines and fixing the current code becames a merging hell).

But i could also send you a copy before commit the changes to verify if it works and even if it's faster. Currently i can't say when i'm ready. Mainproblems i have are CodePage inconsistend CodePages like FireBird CharacterSet "NONE". Where each column can have a different CodePage. Currently i've no idea how to tell the RowAccessor which col uses which CP. (not a problem on DBC-Layer but a huge problem on the Component layer).

So i think it could take a while (one or two weeks). And even more would it be interesing if this patch speeds up something. ??

[miab3]

@EgonHugeist, @mdaems

It might be worthwhile to publish the current version 7.10 as stable before you start a revolution.
(It looks me the stable, more stable than 7.03).

Michal

[miab3]

@mdaems, @EgonHugeist

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

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Michal

[EgonHugeist]

miab3,

It might be worthwhile to publish the current version 7.10 as stable before you start a revolution.
(It looks me the stable, more stable than 7.03).

I found and fixed a loads of remaining issues on 7.0/7.1. But you're right. We should relase 7.0.4-stable and go beta with 7.1. Mark and me already wrote about..

[miab3]

@mdaems, @EgonHugeist

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

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Two little remarks(from D2006):
[Pascal Hint] ZVariant.pas(1939): H2443 Inline function 'ZConvertStringToRawWithAutoEncode' has not been expanded because unit 'WideStrUtils' is not specified in USES list
[Pascal Warning] ZVariant.pas(1926): W1035 Return value of function 'TZClientVariantManager.GetAsRawByteString' might be undefined

Michal

[miab3]

@mdaems, @EgonHugeist

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

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Michal

[miab3]

@mdaems, @EgonHugeist

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

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

This fix(R2374) improves in the D2006/D2007 and in XE2 too.

Michal

[EgonHugeist]

miab3,

thanks, Michal. Yes this was a nasty bug. Equal to R2375 (;

Now we could also assume ftCurrency for fields with equal or less decimal digits of 4. What do you think?

Btw. http://zeosdownload.firmos.at/downloads/snapshots/ its just a snapshot. Mark will merge the latest fixes and 7.0.4 (a bugfix release) will be released the next days...

7.1 goes beta next days too (:

[miab3]

@EgonHugeist, @mdaems,

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

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Michal

There is a NEW comparison ZEOS-FireDAC-UniDAC:
http://blog.synopse.info/post/2013/06/1 ... for-mORMot

[miab3]

@EgonHugeist, @mdaems,

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

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Michal