optimizing big table

hello, i have a table with 29 million rows (1,6 Go) with maritime distances inside working on mysql 3.23.52-Max on a dual xeon 800Mhz 1Go mem example : los angeles > rotterdam 7728 Nmvia panama and english channel los angeles > rotterdam 13456 Nm via cape horn and engl

how to find double

hello, i have a table with 10 500 000 rows on a mysql database how can i find doubles ?? i know how to do it using php, but maybe there is a way using only queries? tks JF leoni - Before posting, please check: http