Informix

 View Only
  • 1.  Performance Informix encryption

    InnerCircle
    Posted Wed March 09, 2022 10:24 AM
    I wanted to ask you guys about your experience with performance degradation of enabled DB encryption in Informix.
    We have tables with 100 columns and 30 million records, does the activated inplace encryption of the Informix DB still play a big role or is it hardly measurable in terms of performance whether it is encrypted or not?

    Suggest we´re using 14.10FC7 with RHEL7 on some multicore CPU VMs

    ------------------------------
    Marc Demhartner
    ------------------------------


  • 2.  RE: Performance Informix encryption

    Posted Wed March 09, 2022 10:26 AM

    If you mean EAR then you won't notice it

     






  • 3.  RE: Performance Informix encryption

    InnerCircle
    Posted Wed March 09, 2022 10:43 AM
    Thanks for prompt reply - and the different option? in transit - so if only a few specific tables would be encrypted / decrypted during runtime ?

    ------------------------------
    Marc Demhartner
    ------------------------------



  • 4.  RE: Performance Informix encryption

    IBM Champion
    Posted Wed March 09, 2022 11:16 AM
    Marc:

    Encryption at Rest (EAR) is at the server level. All storage for the instance is encrypted on disk and in flight between the disk and the server instance. Data is only decrypted when it is accessed inside the server. It would be all data in all tables. Then, separately, you can encrypt the data in flight to clients using SSL and PAM connection types making the encryption end-to-end.

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 5.  RE: Performance Informix encryption

    IBM Champion
    Posted Wed March 09, 2022 10:38 AM
    Marc:

    I agree with Paul. If you are thinking of use Informix Encryption at Rest there is no noticeable impact. CPU usage will be a little bit higher, but if you are not bumping up against 0% idle now it's no biggie.

    If, on the other hand, you are talking about column level encryption, that's a different animal. There will be an impact.

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 6.  RE: Performance Informix encryption

    Posted Wed March 09, 2022 10:42 AM

    The 110% unofficial line I got from IBM was do not use column level encryption cos <quote>its crap</quote>