What makes you think that temporary tables would have better
performance than LIMIT? I'm not saying they do, or don't, just
wondering what makes you say that.
Each query, yes, would make a new temporary table. However, once that
session disconnects, the temporary table goes away. Something to
I make a fulltext-search and store the results in a temporary table
so the user can browser the temporary table (5 results per page...).
I think this is of better performance instead of setting
LIMIT $start,$elements.
correct?
what would happen if several visitors of the website make a search: