Re: [sqlite] SQLite Version 3.7.1
Richard, how to set the default value for SQLITE_FCNTL_CHUNK_SIZE? And is it possible to change this from sqlite3 shell and from tcl interface? -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Version 3.7.1
On Mon, Aug 23, 2010 at 5:50 AM, Alexey Pechnikov pechni...@mobigroup.ruwrote: Richard, how to set the default value for SQLITE_FCNTL_CHUNK_SIZE? And is it possible to change this from sqlite3 shell and from tcl interface? There is no way to set the default value - the value must be set anew with each connection. After we gain experience with this setting, and determine (via actual measurement) whether or not it is useful in reducing disk fragmentation, we will consider providing a PRAGMA interface for it. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Version 3.7.1
SQLite version 3.7.1 is now available on the SQLite website: http://www.sqlite.org/ Version 3.7.1 features improved memory usage reporting abilities, improved index utilization on LIKE and GLOB operators, an increase in the maximum database page size to 64KiB, and a new sqlite3_file_control() interface that will (hopefully) help reduce filesystem fragmentation of database files. Version 3.7.1 also fixes some performance regressions found in 3.7.0 and 3.7.0.1. Additional information is available at http://www.sqlite.org/releaselog/3_7_1.html and at http://www.sqlite.org/news.html Upgrading from 3.7.0 is recommended. Please report any problems to the SQLite mailing list at sqlite-users@sqlite.org or directly to me. Thank you. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users