Hi all; I was playing about with some (probably stupid) queries the
other day, and I noticed that the performance on queries with nested
subqueries was *much* slower, than the same queries with the nested
subqueries represented by temporary tables (win32, 2.8.15). Has
anyone else noticed this? Why would that be true? I sorta expected
that a nested query would be in an intermediate (hidden) temp table
anyway, so that they would behave at the same speed, but such is not
the case.
It doens't matter, in the sense that I will happily create and drop
the temp tables involved, but it did make me wonder.
Involved is an outer query which contains an inner query, which also
contains another inner query.
-- Keith
******************************************************
- Ever notice how 'big' isn't, compared to 'small'?
- Sounds like a Wookie; acts like mad cow.
- I'm not a professional; I just get paid to do this.
- Rules for programming:
1. Get it working, right?
2. Get it working right.
- Things I've learned about multithreaded programming:
123... PPArrvooottieedcc ttm ueelvvteeirrtyyhtt
rhheiianndgge dwi hnpi rctohhg eri aslm omscitanalgt
iowcbh,je engceltvo ebwrah lip,co hso srci abonlt ehb
.ee^Nr waicscee snsoetd 'aotb jtehcet -slaomcea lt'il
m^Ne from two or more threads
******************************************************
