Sign in to follow this  
Followers 0
mrbig1479

whats the best way to compare to large tables ?

2 posts in this topic

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 ?

Share this post


Link to post
Share on other sites



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.


Reading the help file before you post... Not only will it make you look smarter, it will make you smarter.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0