MySQL Performance － EXISTS , IN , Join

CPU ： Pentium(R) Dual-Core CPU       T4400  @ 2.20GHz
RAM：1024 MB
OS：CentOS Linux release 6.0(2.6.32-71.el6.i686 #1 SMP)

Table Engine － MyIsam
BOOK_DBF ---> 66042 rows , 7224996 length
NUSALE_DBF ---> 9321 rows , 372824 length

＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊

mysql> select * from NUSALE_DBF
    -> where not exists(
    -> select * from BOOK_DBF
    -> where BOOK_DBF.BA = NUSALE_DBF.BA);

22 rows in set (40 min 47.75 sec)
............................................................

mysql> select * from NUSALE_DBF
    -> left join BOOK_DBF on BOOK_DBF.BA = NUSALE_DBF.BA
    -> where BOOK_DBF.BA is null;
22 rows in set (48 min 21.97 sec)
............................................................

mysql> select * from NUSALE_DBF
    -> where NUSALE_DBF.BA not in(
    -> select BOOK_DBF.BA from BOOK_DBF where BOOK_DBF.BA=NUSALE_DBF.BA);
22 rows in set (43 min 53.54 sec)
............................................................


+------------+-----------+---------------+------+------+
| SA         | NA        | BA            | SS   | SL   |
+------------+-----------+---------------+------+------+
| 2010-02-20 | 010101010 | 9789864192700 | N    |    1 |
| 2010-02-20 | 010101010 | 9789574828616 | N    |    1 |
| 2010-03-09 | 010101010 | 9789574823307 | N    |    1 |
| 2010-03-09 | 010101010 | 9789574823314 | N    |    1 |
| 2010-03-11 | 010101010 | 9789574823321 | N    |    1 |
| 2010-03-11 | 010101010 | 9789574823338 | N    |    1 |
| 2010-03-17 | 010101010 | 9789574827107 | N    |    1 |
| 2010-03-17 | 010101010 | 9789574823307 | N    |    1 |
| 2010-03-18 | 010101010 | 9789574823819 | N    |    1 |
| 2010-03-18 | 010101010 | 9789574823802 | N    |    1 |
| 2010-03-19 | 010101010 | 9789574823758 | N    |    1 |
| 2010-03-19 | 010101010 | 9789574823765 | N    |    1 |
| 2010-03-24 | 010101010 | 9789574826537 | N    |    1 |
| 2010-03-24 | 010101010 | 9789574823321 | N    |    1 |
| 2010-03-26 | 010101010 | 9789864190133 | N    |    1 |
| 2010-03-30 | 010101010 | 9789574823642 | N    |    1 |
| 2010-03-30 | 010101010 | 9789864190454 | N    |    1 |
| 2010-03-31 | 010101010 | 9789861580142 | N    |    1 |
| 2010-03-31 | 010101010 | 9789574823765 | N    |    1 |
| 2010-05-08 | 010101010 | 9789574823710 | N    |    1 |
| 2010-05-26 | 010101010 | 9789861583556 | N    |    1 |
| 2010-06-05 | 010101010 | 9789861582979 | N    |    1 |
+------------+-----------+---------------+------+------+