Search found 11 matches

by shiva4
23.06.2018, 13:18
Forum: ZeosLib 7.2 Forum
Topic: Sql project speed decreased
Replies: 3
Views: 772

Re: Sql project speed decreased

Understood with the question. The topic is closed.
by shiva4
23.06.2018, 12:29
Forum: ZeosLib 7.2 Forum
Topic: Sql project speed decreased
Replies: 3
Views: 772

Re: Sql project speed decreased

I'll make an adjustment. "Toad for my sql" also works slowly.
by shiva4
23.06.2018, 11:59
Forum: ZeosLib 7.2 Forum
Topic: Sql project speed decreased
Replies: 3
Views: 772

Re: Sql project speed decreased

I wanted to clarify. version of Mysql was 5.7.19 and changed to 5.7.22
by shiva4
23.06.2018, 11:42
Forum: ZeosLib 7.2 Forum
Topic: Sql project speed decreased
Replies: 3
Views: 772

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...
by shiva4
13.12.2017, 09:06
Forum: MySQL
Topic: range check error
Replies: 13
Views: 6007

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;
by shiva4
13.12.2017, 08:41
Forum: MySQL
Topic: range check error
Replies: 13
Views: 6007

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...
by shiva4
13.12.2017, 08:06
Forum: MySQL
Topic: range check error
Replies: 13
Views: 6007

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
by shiva4
12.12.2017, 15:07
Forum: MySQL
Topic: range check error
Replies: 13
Views: 6007

Re: range check error

Well I'll try and write about the result later
by shiva4
12.12.2017, 07:45
Forum: MySQL
Topic: range check error
Replies: 13
Views: 6007

Re: range check error

when there were 176 fields it worked
by shiva4
12.12.2017, 07:37
Forum: MySQL
Topic: range check error
Replies: 13
Views: 6007

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
by shiva4
11.12.2017, 13:35
Forum: MySQL
Topic: range check error
Replies: 13
Views: 6007

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?