Jump to content

OpaJay's Content

There have been 1 items by OpaJay (Search limited from 28-January 20)

By content type

See this member's

Sort by                Order  

#72219 Speeding up searches - can fields be indexed?

Posted by OpaJay on 05 May 2015 - 11:35 AM in Discussion

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)?