Skip to Content
0

More efficient algorith for comparing values in two tables

Apr 16, 2017 at 04:26 PM

54

avatar image

I have two tables:
Table 1: Field 1: AreaRange A, Field B: AreaRange 2

Table 2: Area

I coded it in a way, that it LOOPS AT Table 1, then within that loop LOOPS through each row of Table 2 and checks if the area is within range.

This can not be efficient.

I need multiple results, not just one. In fact each Area in Table 2 is represented by a range in Table 1.

Do you have a suggestion for a more effective approach, which loops less at the tables?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers