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
