Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
  • I am using Linux (3.2.12-3.2.4).

  • I have few "syncer" processes which updates lots and lots SQLite db files in a loop. The database sizes vary from 1 MB to few GB.

  • I have a "searcher" process which can query those DBs and return matched results.

I am looking forward to tune some kernel parameters to get maximum IO performance.

share|improve this question

Your performance bottleneck is not the I/O but your choice of database engine. SQLite is just not designed for the kind of thing you're are doing and has pretty lousy performance even at the best of times.

share|improve this answer

Have you tried tuning sqlite at first? It's all dependent on your requirements but there's at least PRAGMA synchronous and lots more (googleable).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.