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

Reply via email to