Relationships faster than searches ?

[cclub75]

With large database, I'm wondering what technique is faster : perform a search or go related record with a relationship ?

Chris

[Fenton]

I don't know whether there's less of a difference with 7 (don't have any really large files yet), but in 6 a Go To Related Record is faster. Logically you would expect so, because the relationship has a more limited index to look at.

They use a different type of search. A related match is "exact," but for each line (which is different from an exact Find). A default Find is more like "starts with."

[Computer Geek]

I never timed them, but go to related record is pretty quick. My database is 10000+ and I don't have a problem.