Optimizing Informix Applications (INFORMIX SERIES)

Optimizing Informix Applications is a comprehensive guide to improving the performance of database applications built on the Informix-SE, Informix-OnLine, and Informix-OnLine DSA engines. This book is an essential resource for developers and database administrators seeking to improve productivity and system quality.Among the topics covered are: Planning strategies that lead to more efficient databases; setting up an optimization test environment; indexing approaches that offer significantly improved performance; making the best use of the Informix optimizer; refining your SQL statements for more efficient execution; developing and maintaining efficient application code; tuning the Informix database engines; and taking advantage of data fragmentation and parallel processing.Optimizing Informix Applications contains numerous examples, including source code, database layouts, and hardware configurations. A chapter of case studies illustrates the optimization challenges Informix developers encounter most often, and the best solutions. If you design, develop, or administer Informix applications, this book brings together a world of information for making them faster, more reliable, and more cost-effective.