title: Fastest way to search for RFID in sql
body: <p>What would be the fastest way to search for an RFID in sql?
  If have RFID  that has 4 bytes as identifier,
  so I can do a search for</p>
  <pre><code>Where u.RFID1 = a And u.RFID2 = z And u.RFID3 = e And u.RFID4 = r &quot; 
  </code></pre>
  <p>Or I can make the RFID into a bigint</p>
  <pre><code>((RFID1*256+RFID2)*256+RFID)*256+RFID4 and search for that value.
  </code></pre>
  <p>What would be the fastest in SQL? My guess would be the bigint (1 column instead of 4)</p>
  <p>Does anyone have experience with this? (before I write test code...)</p>