2011-02-20, 22:57
Kewlj1313 Wrote:Try adding skip-name-resolve to your config file. On my windows box it is called my.ini and is in the mysql directory!
Let use know what your speeds are like after that P.S. it took mine about 10 seconds with around 3500 actors!
tboooe Wrote:Try this...
ALTER TABLE movie ADD INDEX ix_idFile(idFile);
after adding skip-name-resolve in my.ini
Code:
[mysqld]
.....
......
skip-name-resolve
and the creation of the index:
Code:
mysql> ALTER TABLE movie ADD INDEX ix_idFile(idFile);
Query OK, 681 rows affected (1.01 sec)
Records: 681 Duplicates: 0 Warnings: 0
my time change from 13 min to 6 min for 4899 actors, it's better but should be much faster I think