Hello, i understand this issue. But i have another question. The order of the steps, i have to do ist not clear for me. At the moment i do that:
Make a new db-file in the windows explorer. Open this file in the console with sqlite3 db-file. Then set the page_size and the cache_size with the pragma statements. Then i i run my c-program, which makes following: Open the db with: sqlite3_open_v2(dstdbase, dbdst, SQLITE_OPEN_READWRITE, 0); Then create-statement and insert statement. then close the db. But when i check the page_size and the chache_size after the c-program is finished i get the old values, not the values which i have entered with the pragma. I think i make a misstake by the order of the steps. I hope anybody can help me. Thank you in andvance. Thork >-----Ursprüngliche Nachricht----- >Von: sqlite-users-boun...@sqlite.org >[mailto:sqlite-users-boun...@sqlite.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: > >> 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, select of the old db, insert in the new db). Nothing more. >> >> But when i read the values for page_size and cache_size of the new >> created db with terminal i get page_size 2048 und cache_size >2000 ( i >> use the pragma statement). >> And it doesn't matter, which values i enter in the sqlite3.c file. >> >> I think that should be only a bagatelle, but i have no idea. >> >> Is someone here, which can help me? > > >The page size for a database is fixed when the database is created. >It is a property of the database file, not a property of the >sqlite3 library. The page size in the sqlite3 source code is >merely the default page size used when creating new database files. > >The default page and cache sizes can be set by command-line >options when compiling. You should not need to modify the >source code. See: > >http://www.sqlite.org/compile.html#default_cache_size >http://www.sqlite.org/compile.html#default_page_size > > >D. Richard Hipp >d...@hwaci.com > > > >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
