Sunday, October 15, 2006

Algorithms, part 2

My original idea didn't work too well, but I've thought of another way to solve the problem, which again divides the work into three:

first query: parts which have different values in both months
second query: for all parts which had a value in the first month, see whether they have a value in the second month
third query: for all parts which had a value in the second month, see whether they have a value in the first month

The second and third queries are similar in nature to my original method, but this way should be faster as the program is not iterating over all the parts, but merely a subset.

Last week was holiday week in Israel. I spent two days learning a new ERP program (and only scratching the surface), and not doing much else with the rest of the time. So there's nothing much to report here.

No comments: