title: How do I find why a python scripts runs in significantly different running times on different machines?
body: <h2>The Facts:</h2>
  
  <ol>
  <li>I am working on a NoteBook with Intel Core 2 Duo 2,26 GHz and 4 Gigabyte of Ram.
  It has a Apache Server and a MySQL Server running.</li>
  <li>My Server (I did <code>lshw | less</code>) shows a 64 Bit CPU with 2,65 GHz and 4 Gigabyte Ram, too. It has the XAMPP-Package running on it.</li>
  <li>The Database structures (tables, indices, ...) are identical and so is the Python script I am running.</li>
  </ol>
  
  <h2>The Problem:</h2>
  
  <p>While the script runs in approximately <strong>30 seconds on my macbook</strong> it took the script <strong>11 minutes on the server</strong>!</p>
  
  <p>What are the points you would check first for a bottleneck?</p>
  
  <h2>The Solution:</h2>
  
  <p>There were two indices missing on one of the machines. I added them and voilá: Everything was super! The `EXPLAIN' keyword of MySQL was worth a mint. =)</p>