OH. MY. GOD.

I was crafting an SQL statement joining three tables, and accepting parameters to limit the results returned from each. Table 1 has 10K records. Table 2 has 100K records. Table 3 has 1 million records. I ran the first test, counting seconds until I got results. One. Two. Three. Four. Five. Six. Seven. Eight. Nine. Ten. Eleven.

Not that bad considering the scope, I thought.

Then I changed the Where condition to filter Table 3 instead of Table 2, and ran the test again. Wuh-- *blink* Results in less than one second. I LOVE VFP.

Chris.