Search found 2 matches

by rossi73
25.08.2005, 08:43
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: TZQuery's Open too slow
Replies: 3
Views: 2439

Hi, well, as I checked... The MySQLCC runs the query (1), then results the query time and the number of records (2), then loads the data and display them (3) in the grid. The Delphi does: Runs the query (1) (this is the Open method, isn't it?), then loads the data and display them (3) (I make it wit...
by rossi73
24.08.2005, 15:23
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: TZQuery's Open too slow
Replies: 3
Views: 2439

TZQuery's Open too slow

Hi there, I've an interesting question. I'm using Delphi7 with ZeosLib 6.5.1, and want to run a query form a MySQL 4.1 dabatase. I have the following query: SELECT A.Field1, A.Field2, A.Field3, MAX(B.Field4) AS NewName FROM Table1 A, Table2 B WHERE BINARY UPPER(SUBSTRING(A.Field1,1,3)) = '123' AND A...