there are a number of enhancements in my list which help the sites with
no dba, eg add a chunk when the first chunk is full, no libaries in
/usr/lib

The benefits for every site will be different but there must be a fw on
the list. Performance isn;t the only think I put in the list.

----- Original Message -----
From: "scottishpoet" <dryburghj@yahoo.com>
Newsgroups: comp.databases.informix
Sent: Thursday, December 16, 2004 12:19 AM
Subject: Re: Running Informix on 2 different Servers in parrallel


> My alter ego was called many things in the past, but and Informix God??
>
> We can say performance is a moot point, but, as I think I have shown in
> my list - which may not be complete - , there is a long (and growing
> list) of new things in IDS 9 that are not there in IDS 7. The longer
> that list becomes the longer it will take DB2 to "catch up"!
>
> Lets be positive! There are a lot of good thinsg in my list!

Yes, there *are* a lot of good things in your list (assuming you are also
wcottishpoet:-)). They are really features, rather than benefits. But they
*are* good things. Are they enough to persuade the average user to pay a
hefty uplift for?

wcottishpoet wrote:
> Neil,
>
> other than the holiday, how about all the following which are available
> in 9.40 ....
>
>
> Improved Performance 8-15%better in internal benchmarks;Fuzzy
> Checkpoints;Shared Statement Cache;New Buffer Management System;B-Tree
> Scanner;Improved Replication Perf; Increased Scalability;Data capacity
> of a single instance 128 PB;Support for more CPUs;Improved support for
> large objects;Higher Availability/Reliability;Restartable Fast
> Recovery;Improved Rollback Performance;Dynamic Log Creation;Improved
> Enterprise Replication (ER);ER / HDR InteroperabilityEnhanced Security
> ;Secure over-the-wire encryption using OpenSSL encryption
> libraries;Configurable user authentication mechanisms using Pluggable
> Authentication Modules (PAMs);More permission check upon
> start-up;Simplified Administration ;Redirected Restore;Full use of
> Tapes;Rename Chunks;New Unix Bundle Installer;No libraries in
> /usr/lib;Order of install;Add Chunks when first chunk is full;Onstat
> enhancements;Explain enhancements;Log Management;Dynamic Lock
> Allocation;Easier Application development ;SQL language
> enhancements;Expanded Unicode support;Improved Extensibility;Enhanced
> API ;Native .Net Provider; LRU_MIN_DIRTY & LRU_MAX_DIRTY; Dynamic
> Adding of Logical Log; SmartBlob Spooling Queue; Spooling Threads;
> Utilities all compiled to handle large files;Redirected Restore; Rename
> Chunks During Restore; Add Chunks When First Chunk of Root DBSpace is
> Full;Enhanced Diagnostics; OnStat Enhancements; Explain Can be turned
> on Dynamically; Support for Long Identifiers;Updated Unicode
> Support;Sequences;Triggers on Select and Views;Order by not in select
> list;ANSI SQL-99 Joins;Describe input;Unions in Sub-queries;Names for
> Return Values;Multiple OUT parameters;Improved support for long
> character strings;Multi-nationalization; Collections;Table
> Functions;Virtual Table interface;User Definded Data
> Types;High-Performance Programming Support;Built-in functions for
> handling complex data;Datablade Support;Enhanced APIs; JDBC;OLE DB;ODBC
> ESQL/C;Even More Platform Support;Quality


Cribbed from a powerpoint slide, complete with typo. "Definded"
indeed! Let alone one or two odd bits of grammar (even for a bullet
list), and odd spacing, and ...

The slide puts each phrase onto the screen, slowly, highlight the
current phrase and then fading a bit. Quite pretty, annoyingly slow.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

neil asked the question "why move to 9 if you don't want your own
datatypes"

This list contains a host of reasons.

OK its from a powerpoint presentation and it has few grammer problems.

I wasn't going to post the 6Mb worth of powerpoint presentation that
more of the detail behind this. if anyone wants to come to Bedfont I'd
be happy to present it to them. maybe the UK User gorup could have this
at their next meeting?




Jonathan Leffler wrote:
> wcottishpoet wrote:
> > Neil,
> >
> > other than the holiday, how about all the following which are
available
> > in 9.40 ....
> >
> >
> > Improved Performance 8-15%better in internal benchmarks;Fuzzy
> > Checkpoints;Shared Statement Cache;New Buffer Management
System;B-Tree
> > Scanner;Improved Replication Perf; Increased Scalability;Data
capacity
> > of a single instance 128 PB;Support for more CPUs;Improved support
for
> > large objects;Higher Availability/Reliability;Restartable Fast
> > Recovery;Improved Rollback Performance;Dynamic Log
Creation;Improved
> > Enterprise Replication (ER);ER / HDR InteroperabilityEnhanced
Security
> > ;Secure over-the-wire encryption using OpenSSL encryption
> > libraries;Configurable user authentication mechanisms using
Pluggable
> > Authentication Modules (PAMs);More permission check upon
> > start-up;Simplified Administration ;Redirected Restore;Full use of
> > Tapes;Rename Chunks;New Unix Bundle Installer;No libraries in
> > /usr/lib;Order of install;Add Chunks when first chunk is
full;Onstat
> > enhancements;Explain enhancements;Log Management;Dynamic Lock
> > Allocation;Easier Application development ;SQL language
> > enhancements;Expanded Unicode support;Improved
Extensibility;Enhanced
> > API ;Native .Net Provider; LRU_MIN_DIRTY & LRU_MAX_DIRTY; Dynamic
> > Adding of Logical Log; SmartBlob Spooling Queue; Spooling Threads;
> > Utilities all compiled to handle large files;Redirected Restore;
Rename
> > Chunks During Restore; Add Chunks When First Chunk of Root DBSpace
is
> > Full;Enhanced Diagnostics; OnStat Enhancements; Explain Can be
turned
> > on Dynamically; Support for Long Identifiers;Updated Unicode
> > Support;Sequences;Triggers on Select and Views;Order by not in
select
> > list;ANSI SQL-99 Joins;Describe input;Unions in Sub-queries;Names
for
> > Return Values;Multiple OUT parameters;Improved support for long
> > character strings;Multi-nationalization; Collections;Table
> > Functions;Virtual Table interface;User Definded Data
> > Types;High-Performance Programming Support;Built-in functions for
> > handling complex data;Datablade Support;Enhanced APIs; JDBC;OLE
DB;ODBC
> > ESQL/C;Even More Platform Support;Quality
>
>
> Cribbed from a powerpoint slide, complete with typo. "Definded"
> indeed! Let alone one or two odd bits of grammar (even for a bullet
> list), and odd spacing, and ...
>
> The slide puts each phrase onto the screen, slowly, highlight the
> current phrase and then fading a bit. Quite pretty, annoyingly slow.
>
> --
> Jonathan Leffler #include <disclaimer.h>
> Email: jleffler@earthlink.net, jleffler@us.ibm.com
> Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/