title: Stress testing an embedded database
body: <p>Our agent uses an embedded database for storing intermediate state. The database is being continuously written to in order to backup the state in case the agent is restarted. We are currently using the Firebird embedded database, which replaced SQLITE, which turned out to perform poorly in a highly concurrent environment of the agent.</p>
  
  <p>However, Firebird is not without its glitches. As we step up with our tests, we start seeing Access Violation exceptions and deadlock reports in the log (whoever is interested in stack traces may view them here - <a href="http://tracker.firebirdsql.org/browse/CORE-3207" rel="nofollow">http://tracker.firebirdsql.org/browse/CORE-3207</a> and <a href="http://tracker.firebirdsql.org/browse/CORE-3209" rel="nofollow">http://tracker.firebirdsql.org/browse/CORE-3209</a>)</p>
  
  <p>Their support is very responsive, however it is difficult for me to strip down our scenario to a bare minimum code sample that crashes the database. </p>
  
  <p>My question - does anyone know of a simple tool to stress test an embedded database really fast?</p>
  
  <p>Thanks a lot in advance to all the good Samaritans out there.</p>
  
  <p>P.S.</p>
  
  <p>Please, do not suggest to write it myself - I am pretty aware of this option and prefer to download something ready instead.</p>