On 2014/05/23 20:54, Stephan Beal wrote:
On Fri, May 23, 2014 at 8:53 PM, Humblebee <[email protected]> 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.
Quite exactly my intention (apologies for not being too clear) - and thanks
Stephen.
To add a little, it might be that between consecutive queries the View /might/ be cached so it seems very fast (SQLite will try its
best to not waste CPU cycles), but as far as I know there is no rule-set for knowing in what circumstances any caching will/won't
definitely happen, or if it will remain so in next versions, etc. So best practice is to try and not make Views from slow select
queries. (The point was a bit of an aside, but since you were learning about views for the first time, I thought it best to mention).
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
