On 2/7/10 7:28 AM, "Anthony Urso" <antho...@cs.ucla.edu> 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 the indexes before the load and add them back after. i work on the assumption that if the data is sorted already then the recreation of the indexes in the last step is faster. but then if you have orthogonal indexes, you have to choose one to sort the rows by. as for performance on accessing the table later in normal use, i guess it depends on the usage patterns. if there's a lot of clustered or sequential table reads then caching might be more effective if the rows are sorted. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
