INSERT DELAYED, wheres the equivelent for UPDATE?

[BB101]

I'm having fun doing a large scale UPDATE on a database table. I found I can do an INSERT DELAYED to do bulk inserts without blocking the apache thread, but there doesn't seem to be an equivelent for updating. Can anyone help?

Thanks

--BB

 

[TonyGroves]

You could use LOW_PRIORITY instead:
[tt] UPDATE LOW_PRIORITY tbl SET ...[/tt]

You can also use LOW_PRIORITY for inserts if you wish. The difference between LOW_PRIORITY and DELAYED is that a DELAYED query returns to the client as soon as the inserts have been queued, regardless of the eventual outcome of the query, but LOW_PRIORITY queries return to the client only after the query has been executed.

 

[BB101]

I know this, I want my UPDATE to return immediately as soon as it is queued, is this possible?

--BB

 

[TonyGroves]

Not that I know of.

 

[BB101]

I found a better way, only ever send a maximum of 100 things in the where clause!

I got it running in less than 0.5 seconds (an acceptable level for now).

snippet:

        $rs = $this->_db->GetAll("SELECT town_id FROM lk_user_town WHERE user_id = '".$uid."' AND active = 1");
        
        $sql = "UPDATE LOW_PRIORITY ref_town SET la = la - 1 WHERE 1=0 OR ";
        $x=0;
        foreach ($rs as $r) {
          $sql .= "id = ".$r['town_id']." OR ";
          if ($x++ % 100 == 99) {
            $sql = substr($sql, 0, -4);
            $this->_db->Run($sql);
            $sql = "UPDATE LOW_PRIORITY ref_town SET la = la - 1 WHERE 1=0 OR ";
          }
        }
        $sql = substr($sql, 0, -4);
        $this->_db->Run($sql);

Hope this helps someone!

--BB