whats the best way to compare to large tables ?

[mrbig1479]

my script is right now something like this

" get table 1 item 1 data - go to table 2 , look for item 1 data ' set up new data....."

" get table 1 item 2 data - go to table 2 , look for item 2 data ' set up new data....."

etc....

any faster way ?

[flyingboz]

Lots of optimizations you can use.

If you sort the tables before the comparision, you can do things like

keep track of match position, so the next element search can begin at last_matched + 1

stop matching when you switch from less than to greater than condition.

very large table matching should probably be moved to a DBMS if performance is a concern.