Search found 22 matches

by killerjohn
03.07.2006, 07:34
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: MySQL 5
Replies: 7
Views: 2506

Yesterday I reinstalled my Windows XP, Delphi 2006, everything, but I've the same problem again.... :( :( :(
by killerjohn
03.04.2006, 14:56
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

I've found a bug - StrToFloat doesn't work on NULL values... StrToFloatDef is a better choice... function TMysqlResult.asExtended: Extended; Begin Result := StrToFloatDef(self.FRawString,0); End; function TMysqlResult.asDouble: Double; var full64: Extended; Begin full64 := StrToFloatDef(self.FRawStr...
by killerjohn
31.03.2006, 14:59
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

WOW!

BindColumn rulez :) i'm not tested yet, but i'll :) :) :) thank you very much!
by killerjohn
31.03.2006, 13:16
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

Have somebody some experience with the MyDAC component pack ? (http://crlab.com/mydac)
by killerjohn
31.03.2006, 12:55
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

it's simple... this code on 15400 records (all columns and rows needed) :

<----------------- 0 second
sql.Open;
<----------------- 1 second
While not sql.Eof Do
Begin
sql.Next;
End;
sql.Free;
<----------------- 10 second
by killerjohn
31.03.2006, 12:26
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

When I change the Delphi code to this :

sql.Open;
While not sql.Eof Do
Begin
sql.Next;
End;
sql.Free;

my program is not faster - Zeos is toooooo slow.... :(
by killerjohn
31.03.2006, 12:22
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

Hello! 1st : sorry for my bad English... Please give me some hint about this problem: :cry: Tables: create table DEF_OBJECT ( ID INTEGER not null, OBJECT_TYPE_ID INTEGER not null, LAST_DETAIL_ID INTEGER not null, INACTIVE TINYINT UNSIGNED not null default 0, INTEGRATED TINYINT UNSIGNED not null defa...
by killerjohn
18.01.2006, 09:24
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

I've checked TZQuery, but there is no RequestLive property. Only hidden in the source code :) :?:
by killerjohn
12.01.2006, 22:24
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

I'm using TZReadOnlyQuery.... I think it's faster because it's "read only". or not ? :oops:
by killerjohn
11.01.2006, 18:30
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

Hi!

I need all 90.000 records, and all columns. This is a table with GPS navigation coordinates , and I use very complex calculations with Delphi. :(
by killerjohn
09.01.2006, 15:37
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4492

speed of select

I've the following piece of code (MySQL 5.0.15 and Delphi 2006). The result is about 90.000 records. #1 execution time is about 2 seconds. #2 execution time is about 15 minutes. Why??? :cry: //#1 list.sql.text := 'SELECT * FROM POSITION_001 ORDER BY D_SECONDS;'; list.open; //#2 while not list.eof do...
by killerjohn
09.01.2006, 15:31
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: executable file size
Replies: 8
Views: 1757

thank you :(
by killerjohn
07.01.2006, 21:15
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: executable file size
Replies: 8
Views: 1757

Are there any compiler directives to disable TZQuery, TZTable, TZStoredProc, TZSQLMetadata, TZSQLProcessor, TZSQLMonitor, TZSequance components ? (I need only TZConnection, TZReadOnlyQuery, TZUpdateSQL) :oops:
by killerjohn
06.01.2006, 16:47
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: executable file size
Replies: 8
Views: 1757

Thank you very much!
by killerjohn
02.01.2006, 19:51
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: BDS 2006 and MySQL 5.0
Replies: 5
Views: 1848

How can U install Zeos under D2006 ??? I've "invalid pointer operation" message :(