Search results: Informix

Showing 56 of 1690

Allow "group commit" as other RDBMS

For high use OLTP systems, there can be a lot of I/O pressure on the logical log due to intense rate of logical log buffer flushing (most customer don't ant data loss so they use UNBUFFERED LOG). Setting BUFFERED LOG at session level would hardly ...

over 11 years ago in Informix / Informix Server 3 Future consideration

4 VOTE

Implement nested loop join of external and indexed tables

We raised a support case for this, but creating here will help it progress. The description was as shown below. Please vote for it! Regards,Doug LawryOninit Consulting Try this in the "stores_demo" database: SET EXPLAIN ON;SELECT {+USE_NL(cust...

over 2 years ago in Informix / Informix Server 0 Not under consideration

15 VOTE

UTC/GMT timestamp conversion function for Informix database

Informix does not have a UTC/GMT timestamp conversion function. Requirement :---------------------------------1) Cast function to convert from a particular datetime to UTC datetime based on the current timezone2) Cast function to convert from sysd...

over 10 years ago in Informix / Informix Server 1 Not under consideration

4 VOTE

Fixing IPA in a 15TB OLTP database or large database

We have a 15 TB size oltp db running in 12.10.FC12. We want to fix the data with pending IPA,however, we cannot use the traditional way due to : - we cannot put the DB offline for hours to fix the data with pending IPA and it will be between 5 to ...

almost 3 years ago in Informix / Informix Server 2 Not under consideration

2 VOTE

Make range fragmentation work on high-write systems

Our application is INCREDIBLY write-heavy with highly transient data. Frankly, it doesn't even belong in Informix at all; it ought to be in something like MongoDB or even an in-memory DB. [I'm not kidding: 75-90K inserts per minute, involving BYTE...

over 1 year ago in Informix / Informix Server 0 Submitted

3 VOTE

SQL Trace filtering

SQLTrace enable the DBA to get the query plan of all the queries executed by a user (when mode=user) or by all users (when mode=global). Given that nowadays web applications and/or APIs use connection pooling, they submit a large number of queries...

over 2 years ago in Informix / Informix Server 0 Not under consideration

4 VOTE

NUMA aware memory allocations.

In a system with more one NUMA node sometimes best to have all memory allocated on the first NUMA node for performance. E.g. With 2 NUMA nodes with 300Gb each, pin the lowest number CPU VPs pinned to the first NUMA node and allocate all hugepages...

about 3 years ago in Informix / Informix Server 0 Future consideration

13 VOTE

Refresh for SSL Listeners (reload certificates)

Today, until current version (12.10 xC4) isn't possible to update/replace/implement a SSL certificate without restart the engine. This RFE include two related feature : 1) Allow stop/start SOCSSL listeners using command "onmode -P" and with this r...

almost 11 years ago in Informix / Informix Server 0 Not under consideration

10 VOTE

Backup / ReadAhead Performance

To speedup backup time, it would be nice if Informix can read with more than 64k from disk. Example 12G SAS SSD - read 100 GByte with dd iflag=direct:Blocksize Throughput Time64k 197 MB/Sec 519 Sec (8:39)256k 438 MB/Sec 233 Sec (3:53)2048k 1186 MB...

over 8 years ago in Informix / Informix Server 0 Not under consideration

6 VOTE

Multi Row Insert

Support Multi Row Insert: insert into table1 (col1, ..., colx) values (1, ..., x), ... (1000, ..., x) ; Using Multi Row Insert multiple rows can be inserted with just one statement. Other RDBMs provide this feature with a performance improvement o...

over 5 years ago in Informix / Informix Server 2 Not under consideration

Please enter your email address

FILTER BY CATEGORY