SQLite Forum

partial file load?
What leads me to believe that is the time it takes to open the db file in any client I've tried (e.g. SQLite Expert or python sqlite3 interface), and the corresponding disk activity I see until the database becomes available. Large db files (several GB) take minutes, small files (few MB) take seconds. The sequence of operations is open db file, run the sql script below, close db file:

  'n'||'='||count(*)||'+'||group_concat(namelen,'+') as db_schema
  select name, name||'='||length(sql) as namelen, type from sqlite_master
  WHERE type = 'table' and name not like 'Persistent%'
  order by name
group by type