Progress 9.1C
Single-user
Query : for each
FIELDS() where [field]
Index is available on the [field]; not the primary
No of records returned ~ 30 000
Only connect to the db - via Data Dictionary - and open procedure editor.
First time takes 40 sec
Second time 1 sec
Close procedure editor and data dictionary - so close progress , restart AdminService for Progress.
Connect again and run the query : 1 sec
Restart the computer , connect and run query : 40 sec
Second time : 1 sec

Do you have any explanation please.
Thanks.
Single-user
Query : for each
Index is available on the [field]; not the primary
No of records returned ~ 30 000
Only connect to the db - via Data Dictionary - and open procedure editor.
First time takes 40 sec
Second time 1 sec
Close procedure editor and data dictionary - so close progress , restart AdminService for Progress.
Connect again and run the query : 1 sec
Restart the computer , connect and run query : 40 sec
Second time : 1 sec

Do you have any explanation please.
Thanks.