On Thu, Feb 13, 2003 at 05:57:54PM +0300, Artem Koutchine wrote:
>
> > The effect is you limit the possible rows to a small amount really
> quick
> > with a simple join. The details of the search are handled bij a like
> which
> > can get as complicated as you like using OR`s, NOT`s etc; it won`t
> need more joins or anything anyway. The need for temporary tables is
> gone as well!
>
> I wonder if there is something bad in creating 5-20 temporary tables
> every
> minute or so?
AFAIK not. They can make life really easy every now and then :)
Threads: 83 Questions: 253527481 Slow queries: 659 Opens: 735739 Flush
tables: 1 Open tables: 1231 Queries per second avg: 227.646
Most of these 'Opens' are temp tables. I use them often in cases where one
big join would be much slower.
The thing you have to be careful for (in the fulltext system you are working on)
is to handle the cases when somebody enters a keyword which will return
tens of thousends of results. The joins using the tmp tables will
get really slow (And might block the rest f your users if you use myisam)
--
The Moon is Waxing Gibbous (87% of Full)
tty.nl - 2dehands.nl: 69830
---------------------------------------------------------------------
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
