As Alban pointed out encrypting the search value and compare stored
encrypted value is very fast though it can't do LIKE search.
After I received valuable input from Merlin, Bill and John, I did some
research regarding "search against encrypted field" in general and as in
everyone's advice, I must
On Sat, Nov 14, 2009 at 5:08 PM, John R Pierce wrote:
> Naoko Reeves wrote:
>>
>> I have a encrypted column use encrypt function.
>>
>> Querying against this column is almost not acceptable – returning 12 rows
>> took 25,908 ms.
>>
>> The query was simply Select decrypt(phn_phone_enc) FROM phn WHE
On 14 Nov 2009, at 22:27, Naoko Reeves wrote:
> I have a encrypted column use encrypt function.
> Querying against this column is almost not acceptable – returning 12 rows
> took 25,908 ms.
> The query was simply Select decrypt(phn_phone_enc) FROM phn WHERE
> decrypt(phn_phone_enc,’xxx’,’xxx’) L
"Naoko Reeves" wrote:
>
> Merlin,
> Thank you for your quick response. I see... our security requirements are:
> We are encrypting PII information within our DB and because of the sensitive
> nature of our data, we must balancing both performance and security to meet
> our client requirements.
>
Naoko Reeves wrote:
I have a encrypted column use encrypt function.
Querying against this column is almost not acceptable – returning 12
rows took 25,908 ms.
The query was simply Select decrypt(phn_phone_enc) FROM phn WHERE
decrypt(phn_phone_enc,’xxx’,’xxx’) LIKE ‘123%’
So I built index l
Merlin,
Thank you for your quick response. I see... our security requirements are:
We are encrypting PII information within our DB and because of the sensitive
nature of our data, we must balancing both performance and security to meet our
client requirements.
Our clients are mainly lawyers and h
On Sat, Nov 14, 2009 at 4:27 PM, Naoko Reeves wrote:
> I have a encrypted column use encrypt function.
>
> Querying against this column is almost not acceptable – returning 12 rows
> took 25,908 ms.
>
> The query was simply Select decrypt(phn_phone_enc) FROM phn WHERE
> decrypt(phn_phone_enc,’xxx’
I have a encrypted column use encrypt function.
Querying against this column is almost not acceptable - returning 12
rows took 25,908 ms.
The query was simply Select decrypt(phn_phone_enc) FROM phn WHERE
decrypt(phn_phone_enc,'xxx','xxx') LIKE '123%'
So I built index like: CREATE INDEX idx_phn_p
