Search found 2 matches
- 25.08.2005, 08:43
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: TZQuery's Open too slow
- Replies: 3
- Views: 2458
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...
- 24.08.2005, 15:23
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: TZQuery's Open too slow
- Replies: 3
- Views: 2458
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...