Informix Performance Tuning

Informix Performance Tuning
Author: Elizabeth Suto
Publisher: Prentice Hall
Total Pages: 190
Release: 1996
Genre: Business & Economics
ISBN: 9780132392372

Practical coverage of the two most recent releases of the Informix database server, versions 8 and 7

SQL Performance Tuning

SQL Performance Tuning
Author: Peter Gulutzan
Publisher: Addison-Wesley Professional
Total Pages: 522
Release: 2003
Genre: Computers
ISBN: 9780201791693

A very practical guide to making databases run faster and better. A poorly performing database application can cost each user time, and have an impact on other applications running on the same computer or the same network. This book will help DBAUs and programmers improve the performance of their databases.

IBM Power Systems Performance Guide: Implementing and Optimizing

IBM Power Systems Performance Guide: Implementing and Optimizing
Author: Dino Quintero
Publisher: IBM Redbooks
Total Pages: 372
Release: 2013-05-01
Genre: Computers
ISBN: 0738437662

This IBM® Redbooks® publication addresses performance tuning topics to help leverage the virtualization strengths of the POWER® platform to solve clients' system resource utilization challenges, and maximize system throughput and capacity. We examine the performance monitoring tools, utilities, documentation, and other resources available to help technical teams provide optimized business solutions and support for applications running on IBM POWER systems' virtualized environments. The book offers application performance examples deployed on IBM Power SystemsTM utilizing performance monitoring tools to leverage the comprehensive set of POWER virtualization features: Logical Partitions (LPARs), micro-partitioning, active memory sharing, workload partitions, and more. We provide a well-defined and documented performance tuning model in a POWER system virtualized environment to help you plan a foundation for scaling, capacity, and optimization . This book targets technical professionals (technical consultants, technical support staff, IT Architects, and IT Specialists) responsible for providing solutions and support on IBM POWER systems, including performance tuning.

Database Tuning

Database Tuning
Author: Dennis Shasha
Publisher: Elsevier
Total Pages: 441
Release: 2002-06-07
Genre: Computers
ISBN: 0080503780

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one. - Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner - Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM) - Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis - Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment - Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series - Describes performance-monitoring techniques that will help you recognize and troubleshoot problems

Configuring and Tuning Databases on the Solaris Platform

Configuring and Tuning Databases on the Solaris Platform
Author: Allan N. Packer
Publisher: Prentice Hall Professional
Total Pages: 556
Release: 2002
Genre: Computers
ISBN: 9780130834171

Covers key performance issues related to using leading databases on Sun servers for system administrators and database programmers. This book brings together best-practice guidelines for every aspect of database tuning on Sun servers.

Informix Guide to SQL

Informix Guide to SQL
Author: Informix Software, Inc
Publisher: Prentice Hall PTR
Total Pages: 852
Release: 1995
Genre: Computers
ISBN:

Designed as a companion volume to the INFORMIX Guide to SQL: Tutorial, this comprehensive reference covers the Structured Query Language (SQL) as it is implemented in Informix products. KEY TOPICS: Outlines the structure and contents of the demonstration database (stores5) and explains the 21 Informix system catalog tables that describe that structure; defines the column data types supported by Informix products and explains data type conversion techniques; describes the various environment variables that can or should be set to properly use Informix products; explains error handling, the system descriptor area and the SQL Descriptor Area (sqlda); details the workings of all the SQL statements supported by Informix products with step-by-step diagrams explaining every clause of each SQL statement; and shows how to create and use stored procedures. MARKET: A reference to SQL for those who already know how to use computers and who rely on them in their daily work.

Database Performance Tuning and Optimization

Database Performance Tuning and Optimization
Author: Sitansu S. Mittra
Publisher: Springer Science & Business Media
Total Pages: 495
Release: 2006-04-18
Genre: Computers
ISBN: 0387218084

Presents an ideal mix of theory and practice, which allows the reader to understand the principle behind the application.; Coverage of performance tuning of datawarehouses offers readers the principles and tools they need to handle large reporting databases.; Material can also be used in a non-Oracle environment; Highly experienced author.

IBM Informix Developer's Handbook

IBM Informix Developer's Handbook
Author: Whei-Jen Chen
Publisher: IBM Redbooks
Total Pages: 510
Release: 2011-01-17
Genre: Computers
ISBN: 0738434701

IBM® Informix® is a low-administration, easy-to-use, and embeddable database that is ideal for application development. It supports a wide range of development platforms, such as JavaTM, .NET, PHP, and web services, enabling developers to build database applications in the language of their choice. Informix is designed to handle RDBMS data and XML without modification and can be extended easily to handle new data sets. This IBM Redbooks® publication provides fundamentals of Informix application development. It covers the Informix Client installation and configuration for application development environments. It discusses the skills and techniques for building Informix applications with Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade®, and Hibernate. The book uses code examples to demonstrate how to develop an Informix application with various drivers, APIs, and interfaces. It also provides application development troubleshooting and considerations for performance. This book is intended for developers who use IBM Informix for application development. Although some of the topics that we discuss are highly technical, the information in the book might also be helpful for managers or database administrators who are looking to better understand their Informix development environment.

Solving Business Problems with Informix TimeSeries

Solving Business Problems with Informix TimeSeries
Author: Vaibhav S Dantale
Publisher: IBM Redbooks
Total Pages: 148
Release: 2012-09-21
Genre: Computers
ISBN: 0738437239

The world is becoming more and more instrumented, interconnected, and intelligent in what IBM® terms a smarter planet, with more and more data being collected for analysis. In trade magazines, this trend is called big data. As part of this trend, the following types of time-based information are collected: Large data centers support a corporation or provide cloud services. These data centers need to collect temperature, humidity, and other types of information over time to optimize energy usage. Utility meters (referred to as smart meters) allow utility companies to collect information over a wireless network and to collect more data than ever before. IBM Informix® TimeSeries is optimized for the processing of time-based data and can provide the following benefits: Storage savings: Storage can be optimized when you know the characteristics of your time-based data. Informix TimeSeries often uses one third of the storage space that is required by a standard relational database. Query performance: Informix TimeSeries takes into consideration the type of data to optimize its organization on disk and eliminates the need for some large indexes and additional sorting. For these reasons and more, some queries can easily have an order of magnitude performance improvement compared to standard relational. Simpler queries: Informix TimeSeries includes a large set of specialized functions that allow you to better express the processing that you want to execute. It even provides a toolkit so that you can add proprietary algoritms to the library. This IBM Redbooks® publication is for people who want to implement a solution that revolves around time-based data. It gives you the information that you need to get started and be productive with Informix TimeSeries.

Web Performance Tuning

Web Performance Tuning
Author: Patrick Killelea
Publisher: "O'Reilly Media, Inc."
Total Pages: 484
Release: 2002-03-19
Genre: Computers
ISBN: 1491950692

As long as there's been a Web, people have been trying to make it faster. The maturation of the Web has meant more users, more data, more features, and consequently longer waits on the Web. Improved performance has become a critical factor in determining the usability of the Web in general and of individual sites in particular.Web Performance Tuning, 2nd Edition is about getting the best possible performance from the Web. This book isn't just about tuning web server software; it's also about streamlining web content, getting optimal performance from a browser, tuning both client and server hardware, and maximizing the capacity of the network itself.Web Performance Tuning hits the ground running, giving concrete advice for quick results -- the "blunt instruments" for improving crippled performance right away. The book then shifts gears to give a conceptual background of the principles of computing performance. The latter half of the book examines each element of a web transaction -- from client to network to server -- to find the weak links in the chain and show how to strengthen them.In this second edition, the book has been significantly expanded to include: New chapters on Web site architecture, security, reliability, and their impact on performance Detailed discussion of scalability of Java on multi-processor servers Perl scripts for writing web performance spiders that handle logins, cookies, SSL, and more Detailed instructions on how to use Perl DBI and the open source program gnuplot to generate performance graphs on the fly Coverage of rstat, a Unix-based open source utility for gathering performance statistics remotely In addition, the book includes many more examples and graphs of real-world performance problems and their solutions, and has been updated for Java 2.This book is for anyone who has waited too long for a web page to display, or watched the servers they manage slow to a crawl. It's about making the Web more usable for everyone.