Hi Bill,I'm not sure that MySQL really is the slow down here. I've been deep into frontend code recently there's a lot of candidates for the slow down: inefficient php, or inefficient use of mysql, the way we load all our JS, Openlayers just being a heavy beast, etc.
Re 3.0 and alternatives to php/mysql. I think main advantage of PHP for us is how easy it is for people to deploy (and maybe how easy it is to hack). I don't know if we'd want to ditch PHP. But I'd definitely consider running postgres/postgis instead of mysql. There's still a trade of on ease of deployments, but postgis is pretty easy to get up and running.
Robbie
On Tue, Jul 17, 2012 at 3:58 AM, Bill Morris
<bill.boykinmorris@...> wrote:
A thought has been bouncing around my head since I started using
Ushahidi a year ago:
Why maintain the connection to MySQL?
I understand the deep integration with PHP, and that most of the
original developers probably come from that kind of background.
However, the MySQL backend is a real drag on the overall
responsiveness of the system. No app I've deployed has taken longer to
load up a map than my ushahidi instances, and I can lay much of the
blame on the fact that spatial data is an afterthought for MySQL,
buckled on instead of built from the ground up. As much as it's an
industry standard, MySQL is being lapped in speed by PostgreSQL,
SQLite and any number of NoSQL options. And it doesn't have anywhere
near the spatial processing and analysis capabilities of PostGIS.
You have acres of code fully-formed. I get that. But while everyone's
talking about a reboot for 3.0, why not explore a basis in PostGIS or
CouchDB? Why not jump out of the PHP/MySQL box completely and build
with jekyll or node.js - something that represents the new paradigm
for speed in delivering managed content?
This has been a voice from the peanut gallery, and you may have
already covered this at length. I've piped up now because I want to
see Ushahidi improve. It's still an amazing tool.
-Bill Morris
Burlington, VT USA
~~~~~~~~~~~~~~~~~~~~~~~~~~
List Archive: http://list.ushahidi.com/
Would you like to receive list mail batched in a daily digest instead? Send a message to:
developers-digest-subscribe@...
To remove your address from the list, just send a message to
the address in the "List-Unsubscribe" header of any list
message. If you haven't changed addresses since subscribing,
you can also send a message to:
developers-unsubscribe@...
For addition or removal of addresses, we'll send a confirmation
message to that address. When you receive it, simply reply to it
to complete the transaction.
If you need to get in touch with the human owner of this list,
please send a message to:
developers-owner@...
--
Robbie Mackay
Software Developer, External Projects
Ushahidi Inc
skype: robbie.mackay