Skip to content

Category Archives: ima

Useful or useless? Follow on post …

23-Feb-10

Way back in May last year I experimented with some IMA tables that showed data types and operators defined in the DBMS.  Further poking around and a table for a list of the function instances is available, drop ima_dbms_fis; \p\g register table ima_dbms_fis ( server varchar(64) not null not default is ‘SERVER’, id integer4 not [...]

Also filed in database, development, Example, ingres | Tagged , , , | Comments (9) »

Useful or useless? You decide.

01-May-09

I’ve been poking around the ADF code and came across these IMA objects for data types and operators in the DBMS. These IMA objects, like many others, exist but are never exposed. Data types The following registration will create a table that contains data type name and the data type description bits. drop ima_dbms_datatypes; \p\g [...]

Also filed in database, development, Example | Tagged , | Comments (1) »

Cached Dynamic Query

22-Mar-08

It has been a very busy few months and the appliance team moves apace and is continuously subjected to requests for new applications and Ingres releases. With the latest release of Ingres one of the new features is cached dynamic query plans; that will benefit any application that uses prepared dynamic queries. Ingres has long [...]

Also filed in database, development, ingres, open source | Tagged , | Comments (0) »

Continuing in the IMA vein …

06-Aug-06

A colleague was describing a performance issue encountered by a customer that eventually led to increasing the number of Ingres Net processes (often referred to as iigcc or comsvr). During installation, the number of comsvr configured to start defaults to 1 and it seems there it will remain in this age of set-and-forget. The topic [...]

Also filed in database, ingres | | Comments (0) »