mrbig1479 Posted April 5, 2008 Share Posted April 5, 2008 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 ? Link to comment Share on other sites More sharing options...
flyingboz Posted April 5, 2008 Share Posted April 5, 2008 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now