title: sqlite3 views affect performance?
body: <p>Trying to understand databases better in general, and sqlite3 in particular:</p>
  
  <p>Are views in sqlite3 mainly an organizational feature, allowing complex queries to be broken into a series of smaller ones; or do views actually affect the performance of queries that use them?  </p>
  
  <p>I noticed that views are stored in the database itself as part of the schema.  Are views stored on disk, updated dynamically as dependent tables are updated; or are they evaluated on demand?</p>
  
  <p>Thanks.</p>