Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
  • 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

2 Answers 2

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 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

Your Answer

 
discard

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.