At 03:06 AM 9/8/99 +0300, Michael Widenius wrote:
"chas" == chas <pan...@skinnyhippo.com> writes:
chas> Skimming from the archives :
chas> a) is JOIN still a low priority off-the-radar 'to do item' ?
chas> it's a bit surprising since i would have thought this one of
chas> the more useful functions which can save a lot of coding.
I assume you mean UNION?
oops sorry - yes, you're right ! we would be in a bit of
trouble if joins were still unsupported and low priority :-)
chas> b) isn't the method outlined below (of creating a temp table)
chas> too slow for web applications ?
No; If you use HEAP temporary tables, this should be as fast as if you
have a native UNION. (In some cases even faster as you can be more
specific in your queries and don't have to rely on the query optimizer)
excellent. thank you - heap tables are really turning out to be my friends. :)
5 messages in com.mysql.lists.mysqlRe: union - any decent hacks ?
