MySQL

Query Performance Tuning in Microsoft Analysis Services: Part 1

by Chris Webb | July 2009 | .NET Microsoft MySQL PHP

In this two-part article by Chris Webb, we will cover query performance tuning, including how to design aggregations and partitions and how to write efficient MDX. The first part will cover performance-specific design features, along with the concepts of partitions and aggregations.

One of the main reasons for building Analysis Services cubes as part of a BI solution is because it should mean you get better query performance than if you were querying your relational database directly. While it's certainly the case that Analysis Services is very fast it would be naive to think that all of our queries, however complex, will return in seconds without any tuning being necessary. This article will describe the steps you'll need to go through in order to ensure your cube is as responsive as possible.

Read Query Performance Tuning in Microsoft Analysis Services: Part 1 in full

Query Performance Tuning in Microsoft Analysis Services: Part 2

by Chris Webb | July 2009 | .NET Microsoft MySQL PHP

In the previous part of the article by Chris Webb, we covered performance-specific design features such as partitions and aggregations. In this part, we will cover MDX calculation performance and caching. We'll see how important caching is to overall query performance.

Read Query Performance Tuning in Microsoft Analysis Services: Part 2 in full

Date and Calendar Module in Drupal 5: Part 1

by Marjorie Roswell | May 2009 | MySQL Content Management Drupal Open Source PHP

This is the first part of a two-part article series by Marjorie Roswell. All of the recipes in this article require CCK and the date field (also Views, and Views UI), so we won't take the space to list them in every ingredient list. In this two-part article, we create a wide variety of views, mostly from a single workshop content type. Several of the views implement style plug-ins, which appear as new options in the Views Type drop-down. If you are still working on the 1.x versions of Date, be sure to check out Recipe 44, Upgrade Date and Calendar Modules which will be discussed in the next part.

Read Date and Calendar Module in Drupal 5: Part 1 in full

Debugging REST Web Services

by Samisa Abeysinghe | July 2009 | Architecture & Analysis MySQL PHP Web Development

Learning how to figure out why things are going wrong is one of the key aspects of developing software. We call it debugging. While dealing with REST services and clients, things can go wrong and it would help a great deal to know how to find out what is causing the problems.

In this article by Samisa Abeysinghe, we will look into the techniques such as message capturing and analyzing to get to know if things are going fine, and if not, what sort of problems are causing trouble.

Read Debugging REST Web Services in full

Working with Drupal Audio in Flash (part 1)

by Travis Tidwell | May 2009 | MySQL Content Management Drupal Open Source PHP

In this 2-part article series by Travis Tidwell, we will cover all the necessary steps to integrate audio content into our Drupal web site by building a custom Flash application that works seamlessly with Drupal multimedia. Here is what we will learn in this article:

  • Working with audio in Drupal
  • Building a custom audio player for Drupal
  • Creating an audio-handling class using ActionScript 3.0
  • Loading and playing audio in Flash
Read Working with Drupal Audio in Flash (part 1) in full

Feeds in Facebook Applications

by Dr Mark Alexander Bain Hasin Hayder | July 2009 | MySQL Open Source PHP

Feeds are a very important part of Facebook Applications. They are used to publish notifications and news in a user's profile. So, feeds are the best way to keep the friends of the users up-to-date about the user's current activities. Feeds are also a great way to publicize your applications, if you know what I mean.

In this article by Dr. Mark Alexander Bain and Hasin Hayder, we will go into the details of managing feeds (both news feed and mini feed) using Facebook REST APIs. The following sections will help you understand what the major differences between these two types of feed are, and how to use them properly in your application.

Read Feeds in Facebook Applications in full
Syndicate content
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software