Re: [sqlite] Subject: Sqlite flushing from cache to disk

Hi Aneesh, I collect some information(see below 3 steps to optimize mem use) to answer your questions. Step 1 ** PRAGMA temp_store ** Step 2 ** Incrment default cache size PRAGMA default_cache_size ** Step 3 ** PRAGMA synchronous ** Step 1 ** PRAGMA temp_store ** Temporary storage is where SQLit

Re: [sqlite] Installing SQLite

http://www.sqlite.org/cvstrac/wiki?p=HowToCompile For compile on windows, Cygwin could be used, see cygwin section. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Read back the specified triggers

sqlite3 test.db .dump > test.sql or sqlite>.output file.sql. sqlite>.dump sqlite>.exit ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Steps to Compile SQlite under Cygwin is updated.

Steps to Compile SQlite under Cygwin is updated. http://www.sqlite.org/cvstrac/wiki?p=HowToCompile A sample with steps are appended. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users