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
In many websites, database access is the most expensive part of producing a web page. This article by Matt Perdeck, author of ASP.NET Site Performance Secret, shows how to identify the most common sources of delays and how to resolve them.
This article shows how to pinpoint and prioritize a number of common bottlenecks, so that you can spend your time where it counts the most. These bottlenecks include:
- Missing indexes
- Expensive queries
- Execution plan reuse
Read Pinpointing Bottlenecks for Better Database Access in ASP.Net in full
SQL Server is a very large subject in itself. Rather than attempting to cover all aspects of SQL Server database access, this article focuses on those areas where you are likely to gain the biggest payoffs.
In this article by Matt Perdeck, author of ASP.NET Site Performance Secret, we will take a look at the following:
- Execution plan reuse
This article by Matjaz B. Juric, author of the book WS-BPEL 2.0 for SOA Composite Applications with IBM WebSphere 7, addresses the problems identified in the previous article, Fault Handling and Signaling in Advanced BPEL, where we discussed the various aspects of fault handling and signaling in BPEL.
In this article, we will cover:
- Isolated scopes
The grid is, without doubt, one of the most widely-used components of Ext JS. We all have data, and this needs to be presented to the end user in an easy-to-understand manner. The spreadsheet (a.k.a. grid) is the perfect way to do this—the concept has been around for quite a while because it works. Ext JS takes that concept and makes it flexible and downright amazing!
In this article by Shea Frederick, Colin Ramsay, Steve 'Cutter' Blades, and Nigel White, authors of the book Learning Ext JS 3.2, we will be:
- Using a GridPanel to display structured data in a user-friendly manner
- Reading data from the server (which provides the data from a database) to display in the grid
This article series by Jason Dentler, author of NHibernate 3.0 Cookbook, shows how to build a flexible, extensible data access layer based on NHibernate and its many query APIs. There are two styles of data access layer common in today's applications. The first recipe shows the beginnings of a typical data access object. The remaining recipes show how to set up a repository-based data access layer with NHibernate's various APIs.
In these articles we will cover the following topics:
- Transaction Auto-wrapping for the data access layer
- Setting up an NHibernate repository
- Using Named Queries in the data access layer
- Using ICriteria in the data access layer
- Using Paged Queries in the data access layer
- Using LINQ specifications in the data access layer
Of these the first two are dealt with in this article.Read NHibernate 3.0: Working with the Data Access Layer in full
Named Queries encapsulated in query objects is a powerful combination. This article by Jason Dentler, author of NHibernate 3.0 Cookbook, shows you how to use Named Queries with your NHibernate data access layer.
The reader will benefit from the previous article, NHibernate 3.0: Working with the Data Access Layer.Read NHibernate 3.0: Using Named Queries in the Data Access Layer in full
In this article, by Matjaz B. Juric, author of WS-BPEL 2.0 for SOA Composite Applications with IBM WebSphere 7, we will learn about fault handling & signaling in BPEL
We will cover the following topics:
- WSDL faults
- Signaling faults
- Handling faults
In this article by Shea Frederick, Colin Ramsay, Steve 'Cutter' Blades, and Nigel White, authors of the book Learning Ext JS 3.2, we'll discuss:
- How a developer goes about tapping into the power of Ext.Direct
- Writing our own server-side stack
- Choosing a configuration that works for our environment
- Building out our API
- Setting up our own Programmatic Router to 'direct' our requests where we need them to go
- Finally, we'll put all of the pieces together
Moodle is currently the world's most popular E-learning platform. The long-awaited second version of Moodle is now available and brings with it greatly improved functionality.
In this article we will address some of the frequently asked questions regarding Moodle 2.0, such as,
- What are the basic requirements for Moodle 2.0
- How can I upgrade to Moodle 2.0?
- What are the changes in the Themes structure for Moodle 2.0?
- What are Cohorts?
Read Moodle 2.0 FAQs in full
As the name suggests, this article by Giulio Bai, author of jQuery Plugin Development Beginner's Guide, is about creating our first, working, and fantastic jQuery plugin! This article deals with the correct creation of a plugin of any sort, the basic outline of a plugin and what is fundamental for successfully developing a plugin from scratch. Step-by-step instructions are provided in order to guide even very beginners to the successful realization of their first plugin.
This article will be about the following topics:
- Defining our own default plugin structure
- Setting the basics for our first plugin
- Getting a step farther
- Dealing with options
- Using functions inside the plugin
- Closures: making functions private
In this article, by Matjaz B. Juric, authors of WS-BPEL 2.0 for SOA Composite Applications with IBM WebSphere 7, we will cover the following topics:
- Long-running processes and microflows
- Overview of BPEL activities
- BPEL extensions
- Assembly diagram
This article, Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, discusses how a system administrator can use the phpMyAdmin server management features for day-to-day user account maintenance, server verification, and server protection. The subject of how non-administrators can obtain server information from phpMyAdmin is also covered. Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.
Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.
This article specifically covers:
- Managing users and their privileges
- Database information
- Server information
In this article by Yuli Vasiliev, author of Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting, you'll look at the basic concepts behind Business Intelligence. Proceeding with the discussion on data and information, it then moves on to describe what business questions you might need to answer, and how to find those answers from the data available at your disposal.
Listed as short bullets, here are the main topics of the article:
- Basic introduction to data, information, and Business Intelligence
- Answering basic business questions
- Answering probing analytical questions
- Asking business questions using data access tool
- Deriving information from existing data
- Accessing transactional and dimensional data
Read Oracle Business Intelligence : Getting Business Information from Data in full
In this article, by Shea Frederick, Colin Ramsay, Steve 'Cutter' Blades, & Nigel White, authors of Learning Ext JS 3.2, we will learn how to use toolbars, which contain buttons that call a function on click, or that pop up a submenu on click, or cycle between several submenu options on each click.
The primary classes we will cover in this article are:
- Ext.menu.Menu: A Container class which by default displays itself as a popup component, floating above all other document content. A menu's child items behave in a similar manner to buttons, and may call a handler function on mouse click. A menu may also be used as a static component within a page.
- Ext.Toolbar: A Container class which arranges its child Components horizontally in the available width, and manages overflow by offering overflowed Components in a popup menu.
- Ext.Button: The primary handler for button creation and interaction. A Component class which renders a focusable element which may be configured with a handler function which is called upon mouse click, or a menu to display upon mouse click.
- Ext.SplitButton: A subclass of button which calls a handler function when its main body is clicked, but also renders an arrow glyph to its right which can display a dropdown menu when clicked.
- Ext.CycleButton: A subclass of SplitButton which cycles between checking individual menu options of its configured menu on each click. This is similar to cycling through different folder views in Windows Explorer.
- Ext.ButtonGroup: A Panel class which lays out child Components in a tabular format across a configurable number of columns.