I have found that direct=Y is only faster for large tables. If you are exporting/importing small tables (or mostly small tables) then you are better off with direct=N