Hi,

>i've found that it takes very long time to show the tempcursor

It really depends on a number of variables, such as how large the part is that you read from the table, how often you read the same area, what the connection latency is, how scattered records are, and so on. SEEK is usually faster when there's no additional filter condition and you read data only once.