Search found 2 matches
- 24.09.2005, 21:38
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: TZQuery - query problem
- Replies: 5
- Views: 2085
TZQuery - query problem
...so, I use zeosdbo-6.1.5-stable version, delphi 7 enterprise environment, database server is hosted locally (MySQL 4.0.18). function TE_Courses.getCourseListFromDateToDateSort(from, to: TDateTime; idDispatcher, idDriver: Integer): TCourseList; var query : string; z : TZQuery; begin query := 'SELEC...
- 22.09.2005, 16:03
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: TZQuery - query problem
- Replies: 5
- Views: 2085
TZQuery - query problem
Hello,
I have problem, I use TZQuery to get 11000 records and it takes about 3 minutes. Query is very simple, like: I think, it is too long. I have RAID0 (2xWD800JB) and AthlonXP2700++ I have no idea what is wrong.
I have problem, I use TZQuery to get 11000 records and it takes about 3 minutes. Query is very simple, like:
Code: Select all
SELECT * from table WHERE something;