Eventually the simple distance formula that I have blogged about turned out to be too inaccurate, even for locations within city bounds. I needed to use a formula to calculate great-circle distance which takes into account that the Earth is a sphere.

He includes the SQL to pull the data in the right format and the PHP code (using Propel) to reproduce it without having to write it by hand (complete with the bind variables to help with security and consistency).

One thing I have noticed, is that quite often, PHP developers who are seeking for new PHP features are prematurely trying to implement them in C. Although, there are definitely cases where you want to write your code in C, I think in some cases PHP is too quickly dismissed.

Developing features in PHP not only takes less time, but is also less prone to bugs, easier to maintain, and more stable and secure. Also, in the majority of cases, whether such a feature were implemented in C or PHP, would not make a significant different to overall application performance.

He gives the example of the ZSearch functionality that they mentioned in the php|architect webcast for the Zend framework - entirely implemented in PHP, not C. He also mentions a point that web developers would do good to take to heart - the bottlenecks usually aren't in the code - it's dealing with external resources that's the problem...]]> Thu, 05 Jan 2006 06:37:38 -0600