CODEWITHSUNDEEP
mysqlsqlite
omer
omer

Reputation: 69

Sqlite performance as website traffic grows

So I have this website I'm about to release, and during development i used Sqlite with the intention of migrating to MySQL before moving to production.

I've just migrated all my data (about 40K rows) to a MySQL database and tested performance against Sqlite. Surprisingly, Sqlite performed about twice as fast!

With that in mind, I'm considering just sticking to Sqlite as it's easier to handle. The only things that I'm worried about is if Sqlite performance will get worse as website traffic grows, and if so, will it get a lot worse or just a little slower.

By the way, I'm aware that Sqlite has trouble with multiple writes at the same time, but that wont be a problem since that database is for reading only.

Upvotes: 1

Views: 279

Answers (1)

CL.
CL.

Reputation: 180270

SQLite doesn't do any fancy table/record locking (it has only a global database lock), so it will be faster if the locks aren't actually needed. (With read-only accesses, and probably only a single user (the web server), there will never be conflicts.)

Furthermore, SQLite is a library that is part of the web server process, so it is likely to be more efficient than a database server running in a separate process.

As long as there will not be any writes, this behaviour will not change.

(See Appropriate Uses For SQLite.)

Upvotes: 2

Related Questions