There are several things you can do to help performance:
- Reorganize the file using the KEYFILE(*FILE) parameter if the physical file is indexed.
- For sequential access, use the SEQUENTIAL(*YES nnn) parameter of the OVRDBF command. The higher the number(nnn) the better up to about 512k characters.
- Create a vector index using SQL. The access times will surprise you.
Comment