-
Notifications
You must be signed in to change notification settings - Fork 128
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[ISSUE] Index on encrypted column #697
Labels
Comments
I'm not sure, but you can try All other solutions are out-of-scope index capabilities. The next suggestion is partitioning which will reduce the size of the index and reduce amount of rows. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Describe the bug
In one of my table, there is an encrypted field
e_phone
. Table has 3 Million of rows. Without using an index, it is taking approx 5sec to search one_phone
field.After creating a functional index as follows:
It is taking less time.
I want to know that what are the other suggested indexes to be create on encrypted columns for searching?
To Reproduce
NA
Expected behavior
NA
Acra configuration files
NA
Environment (please complete the following information):
Acra version: [0.95.0]
Database server and its version: [MySQL 5.7, MySQL 8]
Installed components:
Data-in-transit encryption between Acra and the client-side application:
Installation way:
Additional context
NA
The text was updated successfully, but these errors were encountered: