John,

Can you show us the command(s) you are using to pull the 5000 records *and* the exact expressions for each TAG in the table(s) involved?

It still may be that you are not fully exploiting Rushmore.

Good luck,

JimN

>Hi,
> Thank you for your suggestion.
> I have change my ALLTRIM(Card_no) to card_no for my index. However, it still take 1 minute to pull 5000 records from my server.
> I have tried to set my server network setting from 10 Full mode to AutoMode. It seem the performance improve alot!!!! 4 SECONDS!!!! It is same performance with 100 Full mode.
> Any ideas?
>
>Thank you