mysql

The Problem I've been running a mobile GPS tracking service, MoosTrax (formerly BlackBerry Tracker), for a few years and have encountered a large amount of data in the process. A user's phone sends its location to the server and it is stored in a MySQL database. Each "location" entry is stored as a single row in a table. Right now there are approximately 12 million rows in the location table, and things are getting slow now, as a full table scan can take ~3-4 minutes on my limited hardware....

Yes, I recently made a post saying that MoosTrax will be going away forever. Due to all the comments and feedback, it is obvious to me that there are many people that enjoyed the service – so I’m going to bring it back. I’m moving my database backend from CouchDB to MySQL, so my issues with CouchDB won’t prevent me from providing MoosTrax. I have been working a lot on migrating the site and fixing it up…so I really hope to have it up in the next week or so....