0
  • 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.

2

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.

0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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