Search found 11 matches
- 23.06.2018, 13:18
- Forum: ZeosLib 7.2 Forum
- Topic: Sql project speed decreased
- Replies: 3
- Views: 783
Re: Sql project speed decreased
Understood with the question. The topic is closed.
- 23.06.2018, 12:29
- Forum: ZeosLib 7.2 Forum
- Topic: Sql project speed decreased
- Replies: 3
- Views: 783
Re: Sql project speed decreased
I'll make an adjustment. "Toad for my sql" also works slowly.
- 23.06.2018, 11:59
- Forum: ZeosLib 7.2 Forum
- Topic: Sql project speed decreased
- Replies: 3
- Views: 783
Re: Sql project speed decreased
I wanted to clarify. version of Mysql was 5.7.19 and changed to 5.7.22
- 23.06.2018, 11:42
- Forum: ZeosLib 7.2 Forum
- Topic: Sql project speed decreased
- Replies: 3
- Views: 783
Sql project speed decreased
Hello. There is such a development of "LimeSurvey" which uses the Mysql database (v.5.7). I wrote the program on delphi 5 and ZEOSDBO-6.6.5-stable which executes sql query to several mysql database tables (v.5.7). This sql-request was executed less than 1 second. Recently I had to change t...
- 13.12.2017, 09:06
- Forum: MySQL
- Topic: range check error
- Replies: 13
- Views: 6064
Re: range check error
Looked in the source files of version 7.2.0 this restriction remains.
file ZPlainMySqlConstants.pas
string
MYSQL_ROW = array [00 .. $ ff] of PAnsiChar;
file ZPlainMySqlConstants.pas
string
MYSQL_ROW = array [00 .. $ ff] of PAnsiChar;
- 13.12.2017, 08:41
- Forum: MySQL
- Topic: range check error
- Replies: 13
- Views: 6064
Re: range check error
The error appears from the ZPlainMySqlDriver module in function TZMySQL5PlainDriver.GetFieldData Going further I found in the module zplainMySql5 I found MYSQL_ROW = array [00 .. $ ff] of PChar; This is the restriction in connection with which this error arises. I do not know if it's enough to chang...
- 13.12.2017, 08:06
- Forum: MySQL
- Topic: range check error
- Replies: 13
- Views: 6064
Re: range check error
As it turned out, I had version 6.6.5-stable. I work with delphi5 and as I understand the version above 6.6.5 it is not supported. In any case, the delphi5 directory does not exist and it is impossible to install from another directory
- 12.12.2017, 15:07
- Forum: MySQL
- Topic: range check error
- Replies: 13
- Views: 6064
Re: range check error
Well I'll try and write about the result later
- 12.12.2017, 07:45
- Forum: MySQL
- Topic: range check error
- Replies: 13
- Views: 6064
Re: range check error
when there were 176 fields it worked
- 12.12.2017, 07:37
- Forum: MySQL
- Topic: range check error
- Replies: 13
- Views: 6064
Re: range check error
Hi!
I would like to clarify. I have a table with 386 columns and this is not the limit that can be. on this amount I have an error
the version I'm using ZEOSDBO-7.1.4-stable
I would like to clarify. I have a table with 386 columns and this is not the limit that can be. on this amount I have an error
the version I'm using ZEOSDBO-7.1.4-stable
- 11.12.2017, 13:35
- Forum: MySQL
- Topic: range check error
- Replies: 13
- Views: 6064
Re: range check error
Hello!
I had the same problem. There is a table in mysql where the number of columns is greater than 128, the same error occurs. How to solve it?
I had the same problem. There is a table in mysql where the number of columns is greater than 128, the same error occurs. How to solve it?