[sqlite] Question about the update of tuples in sqlite-views

Hello, i have a question about the update machanism for tuples in different views: For example from a table we have three different views. How will be the view updated if one Tuple updated or changed from the DB? (a) only the particular Tuple updated in the different view? (b) or updated the

Re: [sqlite] Problem with PAGE_SIZE and CACHE_SIZEinthe sqlite356c-api

sers-boun...@sqlite.org] Im Auftrag von >Koston, Thorsten (ICT) >Gesendet: Mittwoch, 7. Oktober 2009 10:50 >An: General Discussion of SQLite Database >Betreff: Re: [sqlite] Problem with PAGE_SIZE and >CACHE_SIZEinthe sqlite356c-api > >Hi, > >thank you for your h

Re: [sqlite] Problem with PAGE_SIZE and CACHE_SIZE inthe sqlite356c-api

Hi, thank you for your help. Now i can change the page_size and the autovacuum. But i can't change the cache size. It doesn't matter, what a value i enter in the pragma-statement in the sqlite-exec-command. The cache_size is always 2000. Have anybody a idea what i can do? Thank you in

Re: [sqlite] Problem with PAGE_SIZE and CACHE_SIZE in the sqlite356c-api

qlite.org] Im Auftrag von D. Richard Hipp >Gesendet: Dienstag, 6. Oktober 2009 14:14 >An: General Discussion of SQLite Database >Betreff: Re: [sqlite] Problem with PAGE_SIZE and CACHE_SIZE in >the sqlite356c-api > > >On Oct 6, 2009, at 8:00 AM, Koston, Thorsten (ICT) wrote: >

[sqlite] Problem with PAGE_SIZE and CACHE_SIZE in the sqlite356 c-api

Hello, i have a problem with the sqlite 3.5.6 C-API. I want to change the page_size and the cache_size. I edit this values in the sqlite3.c file. Then i build the sqlite new and start my application, whick uses sqlite. In the application i copy a table of a db to another db (so open an new db,