7.2 testers-thread
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
Re: 7.2-alpa testers-thread
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
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
Re: 7.2-alpa testers-thread
@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
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
Last edited by miab3 on 27.08.2013, 19:04, edited 2 times in total.
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
Re: 7.2-alpa testers-thread
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
Mark
Re: 7.2-alpa testers-thread
7.2 rev 2684 +Delphi XE4 32bit on w7 64bit compile gives:
7.1 rev 2697 +Delphi XE4 32bit on w7 64bit Compiles fine
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'
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
Re: 7.2-alpa testers-thread
Thanks Gaoul, hope i got this solved: R2699
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/
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/
Re: 7.2-alfa testers-thread
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'
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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
Re: 7.2-alfa testers-thread
@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
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