[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-dev
Subject:    Re: [sqlite-dev] Help with a Temp view issue
From:       Richard Hipp <drh () sqlite ! org>
Date:       2013-10-23 17:02:59
Message-ID: CALwJ=MzHKqBGEL3W4hDcQ_RUs9ZNZfM_P5gBX-o+KZu8REp4Yw () mail ! gmail ! com
[Download RAW message or body]

Please send your question to the sqlite-users@sqlite.org mailing list.
This list is for internal design issues of SQLite, not difficulties using
the library, such as your problem.  Thanks.


On Wed, Oct 23, 2013 at 1:01 PM, Vinay Boocha <vinay@manamu.net> wrote:

> Dear All,
>
> We are observing that temp views are using page cache even after setting
> the cache_size= 0. I am stuck debugging this issue for the last two days.
> Any pointers will be greatly appreciated.
>
> When we run a SQL query multiple times on a temp view our custom vfs is
> getting read call only for offset=24 and length=16. I believe its checking
> if the file is updated or not.
>
> *Details:*
>
>
>    1. Temp view is created by joining two tables. One of the table is in
>    an attached database.
>    2. pragma cache_size= 0 is set immediately after opening the
>    connection.
>    3. The cache_size zero is confirmed based on vfs calls for the table
>    in the main database.
>
>
> _______________________________________________
> sqlite-dev mailing list
> sqlite-dev@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev
>
>


-- 
D. Richard Hipp
drh@sqlite.org

[Attachment #3 (text/html)]

<div dir="ltr">Please send your question to the <a \
href="mailto:sqlite-users@sqlite.org">sqlite-users@sqlite.org</a> mailing list.  This \
list is for internal design issues of SQLite, not difficulties using the library, \
such as your problem.  Thanks.<br>

</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Oct 23, 2013 \
at 1:01 PM, Vinay Boocha <span dir="ltr">&lt;<a href="mailto:vinay@manamu.net" \
target="_blank">vinay@manamu.net</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">Dear All,<div><br>We are observing that temp \
views are using page cache even after setting the cache_size= 0. I am stuck debugging \
this issue for the last two days. Any pointers will be greatly appreciated. </div>


<div> </div><div>When we run a SQL query multiple times on a temp view our custom vfs \
is getting read call only for offset=24 and length=16. I believe its checking if the \
file is updated or not. </div><div> </div><div><strong>Details:</strong></div>


<div> </div><ol><li>Temp view is created by joining two tables. One of the table is \
in an attached database. </li><li>pragma cache_size= 0 is set immediately after \
opening the connection. </li><li>The cache_size zero is confirmed based on vfs calls \
for the table in the main database.</li>


</ol></div>
<br>_______________________________________________<br>
sqlite-dev mailing list<br>
<a href="mailto:sqlite-dev@sqlite.org">sqlite-dev@sqlite.org</a><br>
<a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev" \
target="_blank">http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev</a><br> \
<br></blockquote></div><br><br clear="all"><br>-- <br>D. Richard Hipp<br><a \
href="mailto:drh@sqlite.org" target="_blank">drh@sqlite.org</a> </div>



[prev in list] [next in list] [prev in thread] [next in thread]