I’ve heard from a lot of people that Lighttpd and SQL lite offer a lot of speed improvements versus Apache and regular MySQL (w/e that is ).
Can anyone confirm this?
I’ve got a single website I am building which eventually will have many users connected to it through out the day, it will email out a lot of notifiers and continually be updating a few specific tables in the database via Cron daemon running PHP scripts.
Currently I’m on Ubuntu Server (default config for the most part) with the LAMP installation. AMD Athlon 2000xp+, 1Gb memory, 30Gb harddrive.
Any tips in the right direction for me to speed this sucker up would be greatly appreciated. Right now it’s only me using the site locally and it’s even slow for me at times (5 seconds webpage loads !:O)
I’ve heard that Lighttpd is a lightweight Apache clone which does not have all the “bells and whistles” we’ve come to expect. I would expect that the Lighttpd creators would list the differences.
SQLite is a FILE-based database, not a relational database. Thus, if you’re using relational features or need to open several tables at one time, SQLite should be much slower than MySQL.
MySQL is also FILE based (but it uses one or more files per table, not one file for everything)
SQLite is a relational database – all relational really means is that you can have several tables and have those relate to each other (ie. the primary key/foreign key principle). This as opposed to object oriented databases, or NoSQL, which are a different game entirely.
But regardless, SQLite is indeed very slooooow. So unless you maybe have like 5 tables and no more than 10 rows per table I’d stay well clear from it.
As far as Apache alternatives go, I also hear nice things about ngix (Pronounced “Engine X”).
).