Page 9 of 12

Re: ZeosLib 7.1 testers-thread

Posted: 23.08.2013, 12:30
by miab3
@EgonHugeist,

Referring to:
http://sourceforge.net/p/zeoslib/tickets/44/
I can reproduce.
Attached x 2 :
Lazarus-32
pglazarus_32.png
Delphi xe2-32
pgdxe2_32.png
Michal

Re: ZeosLib 7.1 testers-thread

Posted: 24.08.2013, 21:14
by miab3
@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2676:
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.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, 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.

Ticket-44 PostgreSQL fixed.
Still in mySQL nonlinear slow opening table.


Michal

Re: ZeosLib 7.1 testers-thread

Posted: 26.08.2013, 20:47
by EgonHugeist
Sorry Michal for your my missing responce.

We plan to release 7.0.5-stable and 7.1.1-rc. And i'm currently a bit bussy with other things.

Always thank you for your tests, Michal. Hop i got the most remaining issues solved...

Re: ZeosLib 7.1 testers-thread

Posted: 27.08.2013, 12:36
by miab3
@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2685:
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.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, 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.

With the slowdown in MySQL / MariaDB is explained.
Client library libmariadb.dll give this effect.


Michal

Re: ZeosLib 7.1 testers-thread

Posted: 30.08.2013, 09:51
by miab3
@EgonHugeist, @mdaems,

For version:
Zeos7.1-(beta) branches_ testing_R2699
in Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40) - 32-bits
I gets an error:

Code: Select all

C:\codetyphon\typhon\components\pl_ZeosDBO\source\dbc\ZDbcSqLiteStatement.pas(521,43) Error: Wrong number of parameters specified for call to "bind_text"
C:\codetyphon\typhon\components\pl_ZeosDBO\source\dbc\ZDbcSqLiteStatement.pas(521,43) Fatal: Syntax error, ";" expected but "," found
Michal

Re: ZeosLib 7.1 testers-thread

Posted: 02.09.2013, 08:18
by miab3
@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2714:
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.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, 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

Re: ZeosLib 7.1 testers-thread

Posted: 07.09.2013, 11:07
by miab3
@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2717:
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.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, 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

Re: ZeosLib 7.1 testers-thread

Posted: 10.09.2013, 16:41
by miab3
@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2722:
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.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, 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.

Memory leak was gone.
Previously, the Firebird I watched the leak 4MB per 1000 connect / disconnect


It would be else nice to do something with the performance read / write in SQLite.

Michal

Re: ZeosLib 7.1 testers-thread

Posted: 10.09.2013, 19:13
by miab3
@EgonHugeist,

Speaking of speed SQLite, this article explains some:
http://blog.synopse.info/post/2013/06/1 ... cking-mode

Michal

Re: ZeosLib 7.1 testers-thread

Posted: 10.09.2013, 22:30
by miab3
@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2723:
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.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, 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

Re: ZeosLib 7.1 testers-thread

Posted: 12.09.2013, 13:28
by miab3
@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2730:
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.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, 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

Re: ZeosLib 7.1 testers-thread

Posted: 13.09.2013, 23:57
by miab3
@EgonHugeist,

Zeos7.1.1-rc-(beta) branches_ testing_R2731:
Do not compile (Delphi2006)

'IZResultSetMetadata' does not contain a member named 'GetColumnType' at line 676 (676:24) and at line 693 (693:94)

Code: Select all

[Pascal Error] ZDbcSqLiteResultSet.pas(693): E2125 EXCEPT or FINALLY expected
[Pascal Error] ZDbcSqLiteResultSet.pas(695): E2066 Missing operator or semicolon
[Pascal Error] ZDbcSqLiteResultSet.pas(698): E2029 '.' expected but ';' found
[Pascal Fatal Error] ZDbcSqLiteStatement.pas(130): F2063 Could not compile used unit '..\..\src\dbc\ZDbcSqLiteResultSet.pas'
Michal

Re: ZeosLib 7.1 testers-thread

Posted: 14.09.2013, 11:48
by EgonHugeist
Thanx, Michael.

Patch done R2733. wrong working copy. Played to much with 7.2.....

Re: ZeosLib 7.1 testers-thread

Posted: 14.09.2013, 13:19
by miab3
@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2733:
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.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, 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

Re: ZeosLib 7.1 testers-thread

Posted: 16.09.2013, 13:57
by miab3
@EgonHugeist,
Played to much with 7.2.....
Updating Windows 8 to 8.1 killed my Oracle, PostgreSQL, MariaDB, Firebird, Delphi 2007 (and antivirus).
So that I will have to sit on it a while.

Michal