all settings: Name Value Modified auto_vacuum none False automatic_index on False cache_size 2000 False case_sensitive_like off False collation_list [NOCASE], [RTRIM], [BINARY] False count_changes off False default_cache_size 2000 False empty_result_callbacks off False encoding UTF-8 False foreign_keys on False freelist_count 13345 False full_column_names off False fullfsync off False journal_mode delete False journal_size_limit -1 False legacy_file_format on False locking_mode normal False max_page_count 1073741823 False page_count 14071 False page_size 1024 False read_uncommitted off False recursive_triggers off False reverse_unordered_selects off False schema_version 371 False secure_delete off False short_column_names on False synchronous full False temp_store default False temp_store_directory "" False user_version 0 False wal_autocheckpoint 1000 False
Nico Williams wrote: > > What's your page size? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/inserts%2C-performance%2C-file-lock...-tp32814772p32825288.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users