Optimization in mysql

Hi All, I have table from which have to pick up data perform some condition checks and also retrieve ids from respective tables. This is will performed on each record say millions records and then insert into new table. My question is how can I achie...