I had the misconception that a View contains stored data - come to think of it, it would not be practical if the result set was really large.
Thank you everyone for giving me a better understanding of what a view really is about. Cheers. On 5/24/14, Simon Slavin-3 [via SQLite] <ml-node+s1065341n75815...@n5.nabble.com> wrote: > > > > On 23 May 2014, at 7:53pm, Humblebee <fantasia.d...@gmail.com> wrote: > >> I have a question: "so every time you run a query against a view, >> that view's query is run/updated if not cached ". >> >> Does this mean that if the View is Temporary, then it's not cached? >> and for normal views, it's cached? > > The data associated with a VIEW are never stored at all. Creating a view is > more like a way of saving a SELECT statement in your database. When you use > a VIEW in a later statement SQL executes the SELECT at that point. So the > command needed to reproduce the view can be stored in your database, or it > can be TEMP, but the data it would produce is not stored. > > This is oversimplification since the SELECT itself is never executed, SQLite > just figures out how the results would be used in your later statement, but > you understand what I mean. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > If you reply to this email, your message will be added to the discussion > below: > http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75815.html > > To unsubscribe from Simple Select from IN - from a newbie., visit > http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=75751&code=ZmFudGFzaWEuZG9zYUBnbWFpbC5jb218NzU3NTF8MTk4Njk4NTgwNw== -- View this message in context: http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75817.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users