John,
> You have written the following:
>
> I understand the principles but WHEN should they be used or considered ??
>
> Any help appreciated
Something of an assumption here that we're all able to recollect an earlier post? Hope
I'm on the right
wavelength.
I use temporary tables to get over the (current) lacks in MySQL's features:
- sub-selects that cannot be restated as JOINs, eg recursive use of complex GROUP
functions
- as a substitute for VIEWs (which overlaps the above).
Also for speed/efficiencies:
- where a number of different queries will be performed on (essentially) the same
subset of a table/join of
tables, and I want to either save repeated hits ("hammering") against the db, or where
I want/need to
force/guarantee (in as much as I can) that the data will be kept in core/RAM and thus
available at a higher
speed.
Will be interested to hear/learn from, what others have come up with!
=dn
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
