Firebird Leistung Index Max

[haentschman]

Danke...

Sooo...
SQL mit festem Wert
select first 10 * from T_RECORD_DATA where F_timestamp_unix = 1398999942

Delphi-Quellcode:

------ Leistungsinformation ------
Prepare time = 31ms
Ausführungszeit = 0ms
Avg fetch time = 0,00 ms
Current memory = 17.733.168
Max memory = 18.122.312
Memory buffers = 1.024
Reads from disk to cache = 0
Writes from cache to disk = 0
Fetches from cache = 27

SQL Max
select max(F_timestamp_unix) from t_record_data

Delphi-Quellcode:

------ Leistungsinformation ------
Prepare time = 31ms
Ausführungszeit = 41s 559ms
Avg fetch time = 41.559,00 ms
Current memory = 17.726.240
Max memory = 18.122.312
Memory buffers = 1.024
Reads from disk to cache = 82.949
Writes from cache to disk = 0
Fetches from cache = 43.527.043

Also der Flaschenhals wäre gefunden. Da müßte aber der Index doch auch greifen oder?