||One up Performance with Informix Version 12.10|
||Alex Cheng is an IT veteran starting his professional
career as a programmer in 1976 at a large bank, which is
now part of Bank of America. From there, he worked as a
developer, system analyst, database administrator,
project leader at several large companies including
ExxonMobil, Shell Oil, EDS and Compaq Computer.
Currently, he is the manager of Database Architecture and
Administration at Insperity.
Alex received his masters degree from University of South
Carolina at Columbia. He is also the holder of ICDBA (IBM
Certified DBA), MCDBA (Microsoft Certified DBA), MCSE
(Microsoft Certified Systems Engineer), CDP (Certificate
in Data Processing from Institute of Certification for
Computer Professionals) and CTM (Certified Toast Master).
He has been a frequent and popular speaker at the IIUG
Conference, IDUG (International DB2 Users Group)
Conference, PASS Summit (Microsoft SQL Server Conference)
and ISUG (International Sybase Users Group) Conference.|
|IBM released Informix 12.10 in March 2013 and several
versions of enhancements since then. The purpose of this
session is to show those new features and enhancements from
xC1 through xC7, which affect application development and
database performance. The topics to be discussed at this
session include optimizer enhancements, multi-tenancy, JSON
enhancements, avoiding bad query plan caches, prioritizing
databases for automatic update statistics, faster storage
optimization, automatic resource tuning, dynamic private
memory caches, in-place alter on serial data type,
optimizing backups for data deduplication, faster ANSI join
queries, and automatic data compression.