On Wed, Oct 23, 2013 at 2:34 PM, Vinay Boocha <[email protected]> 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 is the pseudo scenario: > > > 1. attach 'portfolio.db' as pdb; > 2. create temp view pnlview select pb,security,quantity,descr from > security s, pdb.portfolio p where s.security=p.security > 3. Execute: select pb,sum(quantity) from pnlview group by pb > 1. When this executed we get vfs read calls to pages in both main and > pdb datbases. > 4. Update pdb.portfolio in a separate component > 5. Repeat steps 3 and 4 > 1. When step 3 SQL is reran we get vfs read calls to pages in main > database. > 2. and one read for portfolio on offset 24 with length 16. > 3. The output of the SQL does not change even though portfolio is > updated in step4 > The scenario above works correctly when I try it using an unmodified SQLite. Perhaps your VFS is not returning the correct result for the read from offset=24, length=16? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
