How good is statement caching under IDS 2000?
On 6th December 1999 rferdy@americasm01.nt.com (Rudy Fernandes) wrote:- Informix’s IDS2000 does support Statement Caching (see the ONCONFIG parameters STMT_CACHE & STMT_CACHE_SIZE). The default is “no caching). However, preparing and reusing statements (which is on a by-connection basis) does provide better results, depending on how often prepared statements are reused. In tests I carried out in the context of our application, this is how they stacked up Arbitrary CPU units used by Informix to accomplish 1000 iterations of a set of SQL statements after establishing a connection • Vanilla (caching off, no preparing) : 100 • Caching ON, no preparing : 70 • Preparing ON, no caching : 30 In other words, preparing/reusing made the application more than 3 times as fast as Vanilla and more than twice as fast as Engine caching. Caution : Results will vary [ 🙂 Am I sounding like a salesman?] In our 3 tier context wherein our Application Server establishes a handful of permanent connections to
