Hi All,
If I got one table A_table with many columns, and a second table B_table is the same but with just primary field and unique field... How much meaningful is the time difference between these queries? 1. SELECT unique_field FROM A_table WHERE prim_field='val'; 2. SELECT unique_field FROM B_table WHERE prim_field='val';
If I split A_table into some tables, and define C_table to be MERGE on the A_table pieces. Is the time difference between selecting from A_table or C_table is meaningful?
You will save a little bit of time on the parser and the query trip over the connection overhead, in the best case (both tables cached in RAM) I would guess about 30% improvement. You may also use UNION instead of the MERGE table. I do not know if it would be faster to use UNION or the MERGE table - I would expect it to be a close match.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
