Since part one and two were uber-successful, here’s an update on my Zend Framework PHP performance situation. I’ve also had this post sitting around since beginning of May and I figured if I don’t post it now, I never will. Disclaimer: All numbers (aka pseudo benchmarks) were not taken on a full moon and are (of course) very relative to our server hardware (e.g. DELL 1950, 8 GB RAM) and environment....
The objective was to select sessions from a table, that are older than two days. Table setup This is the definition: CREATE TABLE `session` ( `id` varchar(32) NOT NULL DEFAULT '', `data` text NOT NULL, `user` int(11) DEFAULT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `user_id` (`user`), KEY `rec_datemod` (`updated`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Right and wrong Wrong query:...
The overall document-oriented approach of CouchDB and the free-form way of saving data are probably the things that appeal to most of us when we first read about this new database. Most of the people that were introduced to CouchDB so far quickly made the decision to use it in production despite the early beta’ish state of the project. We all hate normalization, we all want a faster and responsive database, and some of us want multiple nodes and inter-node replication....
Those of you who run high traffic websites, have probably tried php-cgi/fcgi down the road. And most of us, have gone back to Apache. But now — actually since the middle of 2007 — there’s light at the end of the tunnel. I read a blog post by Evert Pot’s last night (Apache speed and reverse proxies). Evert noted that he tried to use Lighttpd and php-fcgi, all the infamouse tricks with spawn-fcgi....