Performance of your database server is directly tied to how well the underlying operating system is working, and there the performance is driven by the hardware you're using. To fit all of these pieces together—hardware performance, operating system performance, and database performance—you need a good monitoring system.
The simple performance tools on a UNIX-derived system are straightforward to use, and it's easy to show examples of good and bad behavior, the best way to teach how those tools are useful for monitoring. In this article by Gregory Smith, author of PostgreSQL 9.0 High Performance, we will cover iostat; Unix's monitoring tool.Read UNIX Monitoring Tool for PostgreSQL in full
Welcome to PHP social networking! This article by Michael Peacock, author of the book PHP 5 Social Networking, allows users to share media such as images and videos with other users in their network as status updates and profile posts.
During the course of this article you will learn how to integrate different types of media in profile posts, including:
Packt have published a range of new Open Source books this month, for further information click on the links below.
Also, to celebrate Packt's Open Source Awards 2010, We are giving a special offer on all Open Source eBooks. Get any Open Source eBook for just $9.99 now!
Read All New October Open Source Books from Packt in full
Event calendars are essential for many websites. For example, your company website may contain one event calendar to display the events. Showing event information through a calendar helps visitors to view your schedule easier. A good calendar application also helps you to schedule your work. This article by Suhreed Sarkar, author of Joomla! 1.5 Top Extensions Cookbook, shows you how to add an event calendar to your Joomla! site using JEvents.Read Adding an Event Calendar to your Joomla! Site using JEvents in full
For queries where the criteria are not known in advance, such as a website's advanced product search, ICriteria queries are more appropriate than named HQL queries. This article by Jason Dentler, author of NHibernate 3.0 Cookbook, shows how to use the same DAL infrastructure with ICriteria and QueryOver queries.
In an effort to avoid overwhelming the user, and increase application responsiveness, large result sets are commonly broken into smaller pages of results. This article also shows how we can easily add paging to a QueryOver query object in our DAL.Read NHibernate 3.0: Using ICriteria and Paged Queries in the Data Access Layer in full
For Joomla!, there are many popular extensions to show events and calendars. In the previous article we covered adding an event calendar using JEvents. In this article by Suhreed Sarkar, author of Joomla! 1.5 Top Extensions Cookbook, we will discuss a popular extension: GCalendar. JEvents allows you to add events and show them through a calendar. GCalendar allows you to display the Google Calendar on your Joomla! site.
Google Calendar is gaining popularity. If you are a user of Google Calendar, you already know how flexible it is. In this article, you are going to know how to display your Google calendar on your Joomla! site.Read Showing your Google calendar on your Joomla! site using GCalendar in full
Many times, objects contain numerous attributes that define how they look, and they're not always perfectly uniform in relation to the object. For example, a used paint can would have paint dripping down the sides of the can—if we were creating this can in 3D, we'd have to tell Blender that there is a specific spot on our 3D mesh that contains different attributes than the rest of the mesh. This is where UV mapping comes in handy. UV coordinates are, in simple terms, a two-dimensional representation of the texture coordinates of a three-dimensional object. They allow us to tell Blender specific properties about specific areas of our objects in a scene.
In this article by Aaron W. Powell, author of Blender 2.5 Lighting and Rendering, we're going to talk about creating custom textures for our scene and how to bring them into Blender. We will learn how to create a custom UV map and texture for an object in our interior scene.Read Blender 2.5: Creating a UV Texture in full
With the completion of LINQ to NHibernate for NHibernate 3.0, we can easily implement the specification pattern. In this article by Jason Dentler, author of NHibernate 3.0 Cookbook, we will see how to set up and use the specification pattern with the NHibernate repository.Read NHibernate 3.0: Using LINQ Specifications in the data access layer in full
In Oracle Discoverer, you can also use drilling to analyze data, getting a new angle on the data you're dealing with. There are several ways supported by Discoverer in which you can accomplish drilling. For example, you can drill data down to see more detailed information for a certain product. Or, on the contrary, you may need to view data at a higher level, drilling data up from products to categories. Another example is drilling to a related item, allowing you to add a related item that is not currently in the worksheet but can be found in a folder used by the worksheet.
This article by Yuli Vasiliev, author of Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting, will walk you through the simple steps required to drill data on Discoverer worksheets. With the help of many examples, this article will introduce you to the following:
- Navigating a Discoverer worksheet data with drilling
- Drilling up and down
- Drilling to a related worksheet item
- Drilling from a worksheet graph
Windows Communication Foundation 4.0 (WCF 4.0) is a .NET-based application programming interface for building and running connected systems. It enables secure and reliable communication among systems within an organization or across the Internet.
In this article by Steven Cheng, author of the book Microsoft Windows Communication Foundation 4.0 Cookbook for Developing SOA Applications, we will cover:
- Setting up ad hoc Windows authentication over plain HTTP
- Getting an authenticated client identity in a service operation
- Using username authentication with an ASP.NET membership provider
- Sending a clear text username token over unsecured HTTP transport
- Using transport and message security at the same time
Windows Installer XML (WiX) is a free XML markup from Microsoft that is used to author installation packages for Windows-based software. The underlying technology is Windows Installer, which is the established standard for installing desktop-based applications to any Windows operating system. It is used by countless companies around the world. Microsoft uses it to deploy its own software including Microsoft Office and Visual Studio. In fact, Microsoft uses WiX for these products.
In this article by Nick Ramirez, author of the book WiX: A Developer's Guide to Windows Installer XML, we will cover the following:
- Getting WiX and using it with Visual Studio
- Creating your first WiX installer
- Examining an installer database with Orca
- Logging an installation process
- Adding a simple user interface
OmniGraffle has several methods of quickly styling your diagram. This article by Ruben Olsen, author of OmniGraffle 5 Diagramming Essentials, will introduce you to methods and techniques you can use for this purpose.
In this article we will cover the following topics:
- Resizing shapes based on existing shapes on your canvas
- How gridlines might improve your diagramming
- How to efficiently align shapes to each other
Lighting techniques are highly dependent on the location of the scene at hand. The approaches to lighting an outdoor scene are radically different from the techniques used to light an indoor scene. Knowing these differences and when to use each is important when aiming for a believable result.
In this article by Aaron W. Powell, author of Blender 2.5 Lighting and Rendering, we will take a look at:
- Establishing a workflow
- Things to consider when lighting a scene
- Adding and editing lights in Blender
- How to use layers to increase the quality of our render
- What habits are good when lighting and why
In this article by Matt Perdeck, author of ASP.NET Site Performance Secret, we will cover the following:
- Missing indexes
- Clustered index
- Non-clustered index
- Included columns
- Selecting columns to give an index
- Maintaining indexes
- Expensive queries
The main tunable settings for PostgreSQL are in a plain text file named postgresql.conf that's located at the base of the database directory structure. This will often be where $PGDATA is set to on UNIX-like systems, making the file $PGDATA/postgresql.conf on those platforms.
This article by Gregory Smith, author of PostgreSQL 9.0 High Performance, mirrors the general format of the official documentation's look at these parameters at http://www.postgresql.org/docs/current/static/runtime-config.html. However, it is more focused on guidelines for setting the most important values, from the perspective of someone interested in performance tuning, rather than describing the meaning of every parameter. This should be considered a supplement to rather than a complete replacement for the extensive material in the manual.Read Server Configuration Tuning in PostgreSQL in full