MySql Timing problem

[mohausa]

Timing problem
Can you help me please
I am trying to find a solution.

The problem
I have three tables

The first table has more than 100000 records
And the second table has more than 200000 records
Finally, the third table has more than 200000 records

Because the first table changes on a daily basis, I have to check on each record from the first table if it was existed in the second table or not. If it was existed I have to get some information from the third table. If it was not existed in the second table I have to insert a new record in the second table.

HELP ME PLEASE

Those select statements dose no help
This operation takes more than 18 hours to be done
Can I find a better solution?
Thank You

[ZibingsCoder]

What queries are you using that it's taking that long?

[mohausa]

$ss = sql_arr("SELECT aa, bb, cc, dd, ee, ff, gg, hh, ii FROM tableOne WHERE (gg=0 OR gg='') AND ee !='' AND ff!= '' ");


foreach($ss_em as $n){

$cd= mysql_fetch_array(mysql_query("SELECT bb, cc, jj, kk, yu, io, fs FROM tableTow WHERE (bb = $n[bb] AND ee= $k[ee])"));

if(is_array($cd)){
    $info_det = sql_arr("SELECT bb, cc, jj, ys, st, ioc FROM tableThree WHERE bb = $n[bb] AND ee= $n[ee]");

}else // another search
{
        $vv= mysql_fetch_array(mysql_query("SELECT bb, ee, dn, ac FROM tableFour
        WHERE (bb= $n[bb] AND ee= $n[ee]) AND (ac IN 1,23,45,56,67,78,89))"));
       if(is_array($vv))

      BLaBlaBLaBLa BLa BLa
   }
 }

your help please

[mrhappiness]

sounds like some not really good database design...