title: best speed trigger/statements/transaction
body: <p>This is a general sqlite question and specifically as implemented on Android.  </p>
  
  <p>Which offers the best peformance if a deletion on one table would require deletions on another?  This can be accomplished three ways that I see:</p>
  
  <ul>
  <li>To use a trigger</li>
  <li>DELETE statements</li>
  <li>A Transaction wrapping the DELETEs</li>
  </ul>
  
  <p>Hope I've phrased it correctly, I can muck around in sql but I might not express myself properly.</p>