Jump to content


OpaJay

Member Since 05 May 2015
Offline Last Active May 05 2015 05:55 PM
-----

Topics I've Started

Speeding up searches - can fields be indexed?

05 May 2015 - 11:35 AM

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