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 think about if you're using stateless connections (like you have to in PHP4). -Sheeri On 2/26/06, Jochen Kaechelin <[EMAIL PROTECTED]> wrote: > 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: > > each user a temorary table?? > > Thanx. > > -- > fvgi242ss - Webmaster wlanhacking.de > http://mail.wlanhacking.de/cgi-bin/mailman/listinfo > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
