title: Increase the lock timeout with sqlite, and what is the default values?
body: <p>Well known issue when many clients query on a sqlite database : <em>database is locked</em><br />
  I would like to inclease the delay to wait (in ms) for lock release on linux, to get rid of this error.</p>
  <p>From sqlite-command, I can use for example (4 sec):</p>
  <pre><code>sqlite&gt; .timeout 4000
  sqlite&gt;
  </code></pre>
  <p>I've started many processes which make select/insert/delete, and if I don't set this value with sqlite-command, I sometimes get :</p>
  <pre><code>sqlite&gt; select * from items where code like '%30';
  Error: database is locked
  sqlite&gt; 
  </code></pre>
  <p>So what is the default value for .timeout ?</p>
  <p>In Perl 5.10 programs, I also get sometimes this error, despite the default value seems to be 30.000 (so 30 sec, not documented).<br />
  Did programs actually waited for 30 sec before this error ? If yes, this seems crasy, there is at least a little moment where the database is free even if many other processes are running on this database</p>
  <pre><code>my $dbh = DBI-&gt;connect($database,&quot;&quot;,&quot;&quot;) or die &quot;cannot connect $DBI::errstr&quot;;
  my $to = $dbh-&gt;sqlite_busy_timeout(); # $to get the value 30000
  </code></pre>
  <p>Thanks!</p>