>>Additionally, VFPs has caching habilities not so well explained to us, so it is possible that after the first access, those small tables get cached and then you have them already in memory...
>
>So, do you suggest to select code from LookupTable into cursor curLookupTable
>index on code tag code for all lookup tables in order to put them into memory?
>Do you think, it would speed up the process?

I was explaining some alternatives and telling you that it's quite possible that, because of VFP caching habilities, those small tables could be in memory after first access.
Not knowing how many tables, their size, how frequently or how are you using them, there were not suggestions at all...yet.

Barbara's response is more eloquent and complete that mine, anyway. :)