6

Will an SQLite database perform well to around 50 reads/second without locking?

I'm trying to decide whether it'd be feasible for use on a PHP website that won't get 'written' to very often - it'll be mostly reads of the same data from a small handful of tables

palacsint
  • 28,416
  • 10
  • 82
  • 109
Brian E
  • 164
  • 1
  • 9

1 Answers1

4

No problem. The concurrent reading/writing will actually be serialized by SQLite so you don't need to care about it.

For details : http://www.sqlite.org/lockingv3.html

pierrotlefou
  • 39,805
  • 37
  • 135
  • 175