On Fri, May 23, 2014 at 8:53 PM, Humblebee <fantasia.d...@gmail.com> wrote:
> Does this mean that if the View is Temporary, then it's not cached? > and for normal views, it's cached? > No - a TEMP VIEW means the view is automatically destroyed when you close the db connection, and that view is ONLY visible to that specific connection. i believe what he meant was to contrast a VIEW with a TABLE - the VIEW will be re-processed on each run, whereas a TABLE is not. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users