I run large Legacy database (1.3 million names, 1.6 Gb). I am encountering file size problems with Legacy, I just started with RM7. The import process was flawless.
My frustration with RM7 is search speed. Even with the database in a RamDisk, it takes 30 - 45 seconds to jump to a known record number.
Can record numbers be indexed to avoid the serial search through all records, or am I just missing the obvious?
For quicker searches, is it possible to index other fields (such as a custom reference number we use that is similar to Soundex)?