Thank you Igor and Dan. Now I am clear about the concept.
On Sat, 28 Feb 2009 20:07:45 +0530, Dan wrote:
>
> On Feb 28, 2009, at 8:44 PM, Lloyd wrote:
>
>>
>> Hi,
>>
>> When we create a view what happens internally in sqlite? Does it
>> select
>> all the data from the table and then "insert" it
On Feb 28, 2009, at 8:44 PM, Lloyd wrote:
>
> Hi,
>
> When we create a view what happens internally in sqlite? Does it
> select
> all the data from the table and then "insert" it in to the view? or
> would
> the records in the view keep references to records in main table?
> just to
> know
"Lloyd" wrote in
message news:op.up2ds4shlq4...@rccf019
> When we create a view what happens internally in sqlite?
It just saves the SQL text in the database schema, and incorporates it,
sort of like a subroutine, in any query that uses the view.
> Does it
> select all the data from the table a
Hi,
When we create a view what happens internally in sqlite? Does it select
all the data from the table and then "insert" it in to the view? or would
the records in the view keep references to records in main table? just to
know whether creating more views on a big in-memory database would
4 matches
Mail list logo