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
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...