Re: Does the order of tuples in a bulk insert impact query performance?

2010-02-07 Thread Tom Worster
On 2/7/10 7:28 AM, "Anthony Urso" wrote: > Does the order of tuples in a bulk insert impact later query > performance? E.g. will sorting the rows before a bulk insert cause > queries to perform better for indexed or non-indexed fields? when i load a large body of data (using INFILE), i remove t

Does the order of tuples in a bulk insert impact query performance?

2010-02-07 Thread Anthony Urso
Does the order of tuples in a bulk insert impact later query performance? E.g. will sorting the rows before a bulk insert cause queries to perform better for indexed or non-indexed fields? Thanks, Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri