Re: About the underlying principles of AES_DECRYPT() and AES_ENCRYPT()

[无 无]

无 无 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