title: MySQL - XML vs Table
body: <p>I'm developing a timesheet for a client in PHP/MySQL. The basic functions is as follows:</p>
  
  <p>User logs in
  User clicks either a clock in or clock out button.
  At the end of the pay period the user submits the timesheet which will send to the accounting department for payroll. 
  The data will be deleted after submit and start a new pay period.  </p>
  
  <p>I don't need to query the data. I just need to store in/out timestamps, hours worked and total hours per pay period. </p>
  
  <p>Now here's the question. Would it be more efficient to have my create user script create a table for each user or to simply store the in/out data in XML as a TEXT column in my main user table?</p>
  
  <p>The XML seems easier to manage but I'm trying to make an efficiency decision.  </p>