title: C# MySQL timeout issues
body: <p>I'm having MySQL timeout issues with a query i'm running.  It's a simple query, but even in a MySQL editor it takes 5 minutes or so to complete.  I'm hoping you guys might know a better method to fix this timeout issue.</p>
  
  <pre><code>            string processedCONString = "SERVER=localhost;" +
                                     "DATABASE=discovery;" +
                                     "UID=;" +
                                     "PASSWORD=;"+
                                     "connection timeout=500000";
          MySqlConnection processCON = new MySqlConnection(processedCONString);
          string mySQLCOMMAND = "update "+ siteString+"_discovery "+
              "set processed = b'0' "
              +"WHERE URL not in (select URL from live)";
          MySqlCommand mysqlprocessCmdInsertItem = new MySqlCommand(mySQLCOMMAND, processCON);
          processCON.Open();
          mysqlprocessCmdInsertItem.ExecuteNonQuery();
          processCON.Close();
  </code></pre>
  
  <p>Yes the UID and Password are left blank here but not in code.</p>
  
  <p>Also, as this database grows the query is going to take longer and longer.</p>