Re: About the underlying principles of AES_DECRYPT() and AES_ENCRYPT()
Posted by:
无 无
Date: July 07, 2022 04:29AM
无 无 Wrote:
-------------------------------------------------------
> In the past two days, I have been testing the
> performance of Mysql using the AES_DECRYPT() and
> AES_ENCRYPT() functions. It is very slow when
> using Mysql for batch insertion. It takes 7
> seconds for 100 entries. The log configuration has
> been modified, and the speed has been improved.
> When using encrypted fields for conditional
> retrieval, the query speed is very fast, and the
> speed is comparable to that without encryption.
>
> Here is my question:
>
> - Why is it so slow when inserting in batches?
> - Why is decryption by calling the AES_DECRYPT()
> function? When a single index of encrypted data is
> so fast, how is the bottom layer implemented? Is
> there an index?
> - How are the two functions AES_DECRYPT() and
> AES_ENCRYPT() implemented, and are there any
> configurable items to configure the encryption
> index?
>
> Hope to get an answer, thanks a lot
Another question is, when querying in batches, whether the underlying Mysql decrypts all data at one time before matching, or decrypts them one by one, and whether the underlying Mysql decrypts decrypts once or multiple times
Subject
Views
Written By
Posted
575
July 07, 2022 04:22AM
Re: About the underlying principles of AES_DECRYPT() and AES_ENCRYPT()
342
July 07, 2022 04:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.