"Lorderon" <[EMAIL PROTECTED]> wrote: > Mabye, is there a way to tell MySQL to limit the temporary table up to 500 > rows? so, when a row is matching into the top 500 rows, the last row will be > dropped out (in case the table is on limit), and the new matched row will be > inserted into the right place in the temporary table...
To find out top 500 of 10,000 rows ordered by some criteria you anyway need to sort these 10,000 rows. :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
