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).

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).

The International PHP Magazine has released the latest edition of their mangazine - the March 2006 issue - packed full of useful and interesting topics.

This month, some of the articles included are:

• Thomas Myer looks at how to get the most performance out of your scripts that use "enterprise XML" (cover story)
• Elizabeth Naramore's look at two sites that cater to off-the-wall subjects, made possible with PHP
• Peter Lavin covers why documentation is critical in a project, and offers some tips on how to keep it up to date
• Jon Stephens' look at partitioning in MySQL
• and much, much more...

If you would like to purchase this issue (or just get a subscription) you can visit their online store and get it right away.

The International PHP Magazine has released the latest edition of their mangazine - the March 2006 issue - packed full of useful and interesting topics.

This month, some of the articles included are:

• Thomas Myer looks at how to get the most performance out of your scripts that use "enterprise XML" (cover story)
• Elizabeth Naramore's look at two sites that cater to off-the-wall subjects, made possible with PHP
• Peter Lavin covers why documentation is critical in a project, and offers some tips on how to keep it up to date
• Jon Stephens' look at partitioning in MySQL
• and much, much more...

If you would like to purchase this issue (or just get a subscription) you can visit their online store and get it right away.