AnsweredAssumed Answered

Theoretical questions about scripting and performance

Question asked by mz5005 on Aug 2, 2017
Latest reply on Aug 2, 2017 by mz5005

I have a large (=many records) table A and a small table B.

I want to compare all values of text-field X in A with those in B.

 

Two ways of course:

1. Value A1 search in B, value A2.. etc or

2. Value of B1 search in A etc.

 

 

1 means more, but smaller searches

2 means fewer larger searches

 

 

Q1 Is there any reason why scripting-wise one of the two methods is better?

Q2 Is there any (theoretical) difference in time-to-finish?

 

 

All input helpful!

Outcomes