General information
Title:
Feel the power of the Fox.
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only