Small tables are frequently stored in memory, but turning them into ordered cursors (no index needed) or arrays might speed things up if they are accessed frequently.
However the time saved might be a matter of tenths of seconds - are you sure that the 'slow points' of your app are in table access?
Of course if you're working with SQL-Server or other remote data then it would definitely be a good idea to turn small lookup files into cursors or arrays early in the program and reuse them.
HTH
Barbara
>
>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?