> I have seen some additional things. In the first case, without the
> POS-attribute, there are nearly 7000 rows in the buffer. This is the

behavior

> as expected, the locate-method walks through the buffer until it has found

the

> record. In this case, the record is the last one, so it has to fetch all

records

> into the buffer.
> But in the second case, with the POS-attribute, there are only 12 rows in

the

> buffer. Can anybody explain me, how the locate-method has found the record

so

> fast ?

Read about horizontal dataset refinement.

In short, the dataset is maintained by bi-directional cursors instead of a
single unidirectional cursor.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com