Hi Informix scentists,
I have the feeling, that most of you didn't notice a new performance feature I introduce with Informix R&D last year.If you like to push up your batch or DS querys, try to set "DIRECT_IO 0x5" . This will enabling the direct i/o for the normal DBSpaces AND the TEMP DBSpaces. It's not that easy to see, that the TEMP DBSpaces didn't work with direct i/o by default - that's the reason we introduce this feature and accelerated large querys and report batches up to 3 times !Thank you very much to Holger K. from the Informix team for support on this new feature.Hi Informix admins: Set the DIRECT_IO parameter in your onconfig file to 0x5 and accelerate your large queries, if available.Have fun on this,Henri Cujass, your friend from leolo IT
A doc request update was made a while back
It is in 14.10.FC2 although undoc'd.
I saw this (in an IIUG presentation?), has anyone done real world testing with this feature?Regards,