Optimizing Macro Record Lookups

[apexearth]

What's the fastest way to do a view lookup in a macro or while using the COMAPI?

Right now I have used either the .Browse or .FilterSelect functions followed by a Fetch or a GoTop and sometimes it can take an outlandish amount of time to perform depending on where the record is and whether I'm doing it in ascending or descending order.

I feel like there must be a better way. Anyone have one?

 

[Jay Converse]

That depends on the .Order.

Search on the index==Good.

Search off the index==Bad.

 

[ettienne]

If you have the key field(s) then set the key values and use .Read - that is the fastest.