7.2 testers-thread

[mdaems]

michal,
is this behavior different compared to 7.0?
Do you know where the extra time is consumed? At opening time or during the reading of the data? If it's at opening, chances are that the issue is with the way the data are cached by the MySQL lib. In the other case we might have a problem asking more records from the server when fetching. This nonlinear behavior isn't something I would expect to be inside zeoslib as the other drivers should essentially use the same code for memory handling, data conversion,...
did you already include a testing program? (sorry, didn't reread all your posts right now)
To avoid we forget this kind of messages, please post them at the bug tracker. a forum is a volatile medium. Essentially for reading a message only once. Rereading is more difficult.
So if we read here that there's a compilation error, right. That's something Michael probably fixes in no time when he reads it. The issue you mention now probably takes a lot of effort in tracing.

Mark

[miab3]

@EgonHugeist, @mdaems,

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

- DXE2 32/64 -> C++(32) - Windows8-64

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

Michal

[mdaems]

That's good news. Thanks for checking. Did you log a bug report with the mariadb people? I suppose they also like to know this.

Mark

[Goaul]

7.2 rev 2684 +Delphi XE4 32bit on w7 64bit compile gives:

Code: Select all

[dcc32 Error] ZSysUtils.pas(2861): E2251 Ambiguous overloaded call to 'StrLen'
  System.SysUtils.pas(10381): Related method: function StrLen(const PAnsiChar): Cardinal;
  System.AnsiStrings.pas(3166): Related method: function StrLen(const PAnsiChar): Cardinal;
[dcc32 Error] ZSysUtils.pas(2880): E2251 Ambiguous overloaded call to 'StrLen'
  System.SysUtils.pas(10381): Related method: function StrLen(const PAnsiChar): Cardinal;
  System.AnsiStrings.pas(3166): Related method: function StrLen(const PAnsiChar): Cardinal;
[dcc32 Error] ZSysUtils.pas(2919): E2251 Ambiguous overloaded call to 'StrLen'
  System.SysUtils.pas(10381): Related method: function StrLen(const PAnsiChar): Cardinal;
  System.AnsiStrings.pas(3166): Related method: function StrLen(const PAnsiChar): Cardinal;
[dcc32 Error] ZSysUtils.pas(5110): E2251 Ambiguous overloaded call to 'FloatToText'
  System.SysUtils.pas(13928): Related method: function FloatToText(PAnsiChar; const; TFloatValue; TFloatFormat; Integer; Integer): Integer;
  System.AnsiStrings.pas(4493): Related method: function FloatToText(PAnsiChar; const; TFloatValue; TFloatFormat; Integer; Integer): Integer;
[dcc32 Error] ZSysUtils.pas(5110): E2010 Incompatible types: 'PWideChar' and 'PAnsiChar'
[dcc32 Fatal Error] ZEncoding.pas(888): F2063 Could not compile used unit 'ZSysUtils.pas'

7.1 rev 2697 +Delphi XE4 32bit on w7 64bit Compiles fine

[EgonHugeist]

Thanks Gaoul, hope i got this solved: R2699

[Goaul]

R2699 32bit

Code: Select all

[dcc32 Error] ZDbcCache.pas(553): E2251 Ambiguous overloaded call to 'StrPLCopy'
  System.SysUtils.pas(10732): Related method: function StrPLCopy(PAnsiChar; const AnsiString; Cardinal): PAnsiChar;
  System.AnsiStrings.pas(3382): Related method: function StrPLCopy(PAnsiChar; const AnsiString; Cardinal): PAnsiChar;
[dcc32 Error] ZDbcCache.pas(2858): E2251 Ambiguous overloaded call to 'AnsiStrComp'
  System.SysUtils.pas(6574): Related method: function AnsiStrComp(PAnsiChar; PAnsiChar): Integer;
  System.AnsiStrings.pas(2941): Related method: function AnsiStrComp(PAnsiChar; PAnsiChar): Integer;
[dcc32 Fatal Error] ZDbcCachedResultSet.pas(534): F2063 Could not compile used unit 'ZDbcCache.pas'

[miab3]

@EgonHugeist, @mdaems,

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

- DXE2 32/64 -> C++(32) - Windows8-64

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- DXE2 32/64 -> C++(32) - Windows8-64

Michal

[miab3]

@EgonHugeist, @mdaems,

Michael,
Could you take a look to the threads:

ExecSQL Access violation with multi-threaded process
http://zeoslib.sourceforge.net/viewtopi ... =17&t=3923

TZConnection is always in transaction state
http://zeoslib.sourceforge.net/viewtopi ... =36&t=3801
and
SQLite foreign_keys issue
http://zeoslib.sourceforge.net/viewtopi ... =36&t=3803

Perhaps the latter is somehow related to the disgraceful speed of up SQLite.

Michal

[miab3]

@EgonHugeist,

Michael,
Applies Zeos7.2-alpha branches_ testing_R2726.
Using SSE3 eliminate from the use of P4 and older AMD Athlon
http://www.insanelymac.com/forum/topic/ ... rocessors/
I would have stopped on the SSE2:
http://en.wikipedia.org/wiki/SSE2#CPUs_supporting_SSE2

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- DXE2 32/64 -> C++(32) - Windows8-64 - C2D

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- DXE2 32/64 -> C++(32) - Windows8.1-64 - C2D

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- DXE2 32/64 -> C++(32) - Windows8.1-64 - C2D

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- DXE2 32/64 -> C++(32) - Windows8.1-64 - C2D

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- Delphi XE2 32/64 -> C++(32)
Windows8.1-64 - C2D

Michal