News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Sebastian Begmann's Blog:
Partitioning with Dates in MySQL 5.1
February 01, 2007 @ 08:03:00

In a new blog entry from Sebastian Bergmann, he looks at some of the issues and bugs that have been submitted to him about the phpOpenTracker project. He takes on one in particular - the database schema.

The biggest problem with phpOpenTracker 1.x is that its database schema is normalized. Even simple phpOpenTracker API calls result in (possibly multiple) SQL queries that involve multiple tables. [...] While the denormalization should eliminate the JOIN-related performance problems, temporal partitioning of the data can further increase the performance.

He talks about what kind of support MySQL currently has for it (5.1) and how, unfortunately, it might not work for his situation (the maximum number of partitions).

0 comments voice your opinion now!
partitioning mysql database phpopentracker issue partitioning mysql database phpopentracker issue


blog comments powered by Disqus

Similar Posts

Christopher Kunz's Blog: Building PHP with cURL and libmysqlclient5

Zend Developer Zone: Zend Framework Hidden Gems: Zend_Db

Ryan Malesevich's Blog: MD5 to SHA-1 in PHP and MySQL (Part 1)

DevShed: Generating View from MySQL to Simulate the Model-View-Controller Schema in PHP

DevShed: Using Advanced Functions to Maintain the State of Applications with PHP Sessions


Community Events





Don't see your event here?
Let us know!


community list install interview release api developer language testing threedevsandamaybe opinion unittest introduction laravel podcast symfony2 refactor series framework code

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework