title: Subtable type stucture in MySQL
body: <p>I would like to know if it is possible to have the following database behaviour:</p>
  
  <ol>
  <li>Create a USER table, with primary key USER_ID</li>
  <li>Data comes in from external source: e.g. "USER_ID, TIMESTAMP, DATA"</li>
  <li>For each user in the USER table, create a table to store only data entries pertinent to USER_ID, and store all incoming Data with the correct USER_ID into that table</li>
  <li>When querying all the data entries for a specific USER_ID, just return all rows from that table.</li>
  </ol>
  
  <p>I could of course do this all in one table "ALLDATALOG" and then search for all entries in ALLDATALOG that contain USER_ID, but my concern is that as the ALLDATALOG table grows, searches will take too long.</p>