Thanks for the tip, here's the results I got back: Now I'm never done a real time test like this before, so I did my best to keep the two conditions as equal as possible.[list][*] select first 40 rows of the table[*] for each row, fetch[*] for each fetch, lookup the designer based on the two methods described above[*] run the fetch through a function that echos out the information in a given manner (identical process for both tests)[/list] for 40 rows: using queries: Ran Analysis in 0.011135 seconds, 0.011551 seconds, 0.01166 seconds using an array: Ran Analysis in 0.007887 seconds, 0.007912 seconds, 0.007984 seconds then I decided to add criteria for the products (in first test there were only 3 designers): this time the query pulled in 5 designers: using queries: Ran Analysis in 0.011026 seconds, 0.011846 seconds, 0.012299 seconds using an array: Ran Analysis in 0.008007 seconds, 0.008027 seconds, 0.007976 seconds still not satisfied, I had it dump the whole products database (191 rows): using queries: Ran Analysis in 0.51082 seconds, 0.53646 seconds, 0.436927 seconds using an array: Ran Analysis in 0.312473 seconds, 0.316537 seconds, 0.398623 seconds I guess that really answers my question. Let me know if I'm skipping something in my testing enviornment. Thanks