SQLite
Wow... I think I finally converted all of this site over to SQLite. So far it's much faster. It's around 300% faster after some tweaking both of the backend and the code. I haven't really looked at the code for over a year or so, and I found several places to speed things up.
Overall I'm pretty impressed. I'm still having some issues with how SQLite stores and processes dates, but I'll work through them.
Overall I'm pretty impressed. I'm still having some issues with how SQLite stores and processes dates, but I'll work through them.