Hi, I know views are stored in the sqlite_master table as: type view: name "myname" tbl_name "myname" rootpage 0 sql "mysqlString" Is this all they are or is there some way the compilation of the view is retained/stored for the next time it is run? I know some databases store Views in raw and compiled to speed things up e.g MS Access (I think) SQL Server Best regards Rob