Hi,
Thank you. I will try what you mentioned.
>>Everything seems fine (except you seem to have two indixes for cardno (is the primary filtered on deleted() ?).
Yes, my primary is filtered on NOT DELETED(). Any wrong here?
Again, the reason I have 2 indexes of card no is, I found that my SQL query is not optimized with only primary key for cardno. Once I add a new index for cardno with regular, my SQL query is optimized and performance increased!!!
Any ideas?
Thank you very much for you suggestion and advises.
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...