Sir,

We have done a encryption by using our own algorithm. it works fine. But during 
the report analysis we are facing the performance issue. Which is not 
appreciated by our users. 


We need only one column to be encrypted and the column size will never exceed 3 
chars. 


We have planed to use the AES_ENCRYPT and AES_DECRYPT by using the "key string" 
as a parameter. We can keep this key string as our security point. We found it 
is giving better performance in all cases.

Can i have  your advise please?

Thank you in advance!

Vikram A




________________________________
From: Vikram A <vikkiatb...@yahoo.in>
To: Johan De Meersman <vegiv...@tuxera.be>
Cc: MY SQL Mailing list <mysql@lists.mysql.com>
Sent: Wed, 29 September, 2010 11:46:18 AM
Subject: Re: Best encription method?


Sir,

I must adopt the encryption. I shall bear the cost of the memory.
Thank you for the guidance. 

Vikram A




________________________________
From: Johan De Meersman <vegiv...@tuxera.be>
To: Vikram A <vikkiatb...@yahoo.in>
Cc: MY SQL Mailing list <mysql@lists.mysql.com>
Sent: Tue, 28 September, 2010 2:08:57 PM
Subject: Re: Best encription method?




On Mon, Sep 27, 2010 at 3:43 PM, Vikram A <vikkiatb...@yahoo.in> wrote:


>Normally, If i need to store an integer value i have to define it as int, If I
>encrypt this, i must define its type as string of different size[it depend upon
>the encryption output] than its original size. It increases the db size. I am
>known that if it is secure i have to choose encryption. but when i choose
>encryption it leads the more memory usage.
>

Well, yes :-) That's part of the price you're going to pay for the security.

As the programmer said; I can make it better, faster and cheaper. Pick any two.
 

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Reply via email to