On Wed, Oct 23, 2013 at 2:34 PM, Vinay Boocha wrote:
> Dear Rich,
>
> I try to communicate better this time.
>
> If I go by calls to my VFS then Yes. The subsequent SQL executions (same
> SQL ran multiple times) will not result in page fetches (only fetch is for
> offset=24 length=16).
>
> Here i
Dear Rich,
I try to communicate better this time.
If I go by calls to my VFS then Yes. The subsequent SQL executions (same
SQL ran multiple times) will not result in page fetches (only fetch is for
offset=24 length=16).
Here is the pseudo scenario:
1. attach 'portfolio.db' as pdb;
2. cre
On Wed, Oct 23, 2013 at 1:50 PM, Vinay Boocha wrote:
> Dear Rich,
>
> Thanks for the response. I guessed it might need some cache but thought it
> will refetch every time to ensure consistency.
>
> My main issue is that temp views are not picking up the update after the
> pages of joined tables g
Dear Rich,
Thanks for the response. I guessed it might need some cache but thought it
will refetch every time to ensure consistency.
My main issue is that temp views are not picking up the update after the
pages of joined tables got updated (tables are updated by another actor in
the system).
An
On Wed, Oct 23, 2013 at 1:20 PM, Vinay Boocha 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.
>
Depending on the query and the s
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
6 matches
Mail list logo
