title: MySQL result to large
body: <p>I have 2 Tables, which both have about 300000 values. Because of technical reasons, we cannot match directly on the timestamp or onn one unique ID.</p>
  
  <p>But we would like to fetch this result:</p>
  
  <pre><code>SELECT * FROM adsDelivered
           JOIN pageViews ON (
              adsDelivered.session = pageViews.session and 
              adsDelivered.referer = pageViews.referer and 
              abs(unix_timestamp(adsDelivered.timeCreated) - unix_timestamp(pageViews.timeCreated)) &lt;= 5
           ) 
           WHERE pageViews.timeCreated &gt;= '2013-03-21 00:00:00' and 
                 pageViews.timeCreated &lt;= '2013-03-21 23:59:59' 
           LIMIT 100
  </code></pre>
  
  <p>The feedback is to large and takes to long time.</p>